取得DB裡所有Table Name

摘要:取得DB裡所有Table Name

MS SQL

SELECT *
FROM INFORMATION_SCHEMA.TABLES
ORDER BY Table_type, table_name

 

Oracle

SELECT * FROM USER_OBJECTS