SQL 列出資料庫中所有的Table

SQL 列出資料庫中所有的Table


MsSQL:

SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE (TABLE_TYPE = 'BASE TABLE') AND (TABLE_SCHEMA = 'dbo')

Access:

SELECT * FROM MSYSOBJECTS

Oracle:

SELECT * FROM USER_OBJECTS