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

+ Recent posts