데이터베이스 테이블 목록 가져오기

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 [너머]