Sql Server系列：SQL語句查詢資料庫中表、視圖、預存程序等組成

標籤：

1. 查看使用者表

select name from sys.tables

select name from sys.objects where type=‘U‘

select name from sysobjects where xtype=‘U‘

　　其中type或xtype值：U = 使用者表 S = 系統資料表 V = 視圖 FN = 純量涵式 TF = 表函數 P = 預存程序  TR = 觸發器

　　D = 預設值或 DEFAULT 約束 PK = PRIMARY KEY 約束 F = FOREIGN KEY 約束 UQ = UNIQUE 約束

SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES

2. 查看視圖

SELECT * FROM INFORMATION_SCHEMA.VIEWS

3. 查看錶/視圖欄位

SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = ‘Product‘ 

-- 視圖VProductSELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = ‘VProduct‘ 

select name from syscolumns where id = object_id(‘Product‘)

SELECT COLUMN_NAME,DATA_TYPE FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = ‘Product‘

Sql Server系列：SQL語句查詢資料庫中表、視圖、預存程序等組成