取得SQL Server 2005中某個資料庫的所有資料表

先切到該資料庫下面

Use DBName

然後下這串指令,會把View與Table都顯示出來

SELECT * FROM INFORMATION_SCHEMA.TABLES

如果只要抓取Table

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

如果只要抓取View

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

 

新增評論

Loading