ORACLE SELECT * FROM USER_OBJECTS WHERE OBJECT_TYPE =’TABLE’ ORDER BY OBJECT_NAME MS-SQL SELECT * FROM sysobjects WHERE type = ‘U’ ORDER BY name MySQL SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = ‘계정명’ 출처: http://darkhorizon.tistory.com/313 [너머]
월별 글 보관함:2017년 8월
ubuntu에서 mysql 완전삭제 후 재설치
apt-get purge mysql-server apt-get purge mysql-common rm -rf /var/log/mysql rm -rf /var/log/mysql.* rm -rf /var/lib/mysql rm -rf /etc/mysql apt-get install mysql-server –fix-missing –fix-broken 출처: http://aesthetic9.tistory.com/entry/ubuntu에서-mysql-완전삭제-후-재설치 [Doing anything and Doing Nothing]