개발 등/DATABASE

DB TABLE 목록 조회

darkhorizon 2013. 7. 29. 13:52
728x90
반응형

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 = '계정명'

728x90