SQL Server
數表:
select count(1) from sysobjects where xtype="U"
數檢視:
select count(1) from sysobjects where xtype="V"
數儲存過程
select count(1) from sysobjects where xtype="P"
SELECT * FROM sysobjects WHERE (xtype = "U")
C = CHECK 約束
D = 預設值或 DEFAULT 約束
F = FOREIGN KEY 約束
L = 日誌
FN = 標量函式
IF = 內嵌表函式
P = 儲存過程
PK = PRIMARY KEY 約束(型別是 K)
RF = 複製篩選儲存過程
S = 系統表
TF = 表函式
TR = 觸發器
U = 使用者表
UQ = UNIQUE 約束(型別是 K)
V = 檢視
X = 擴充套件儲存過程
SQL Server
數表:
select count(1) from sysobjects where xtype="U"
數檢視:
select count(1) from sysobjects where xtype="V"
數儲存過程
select count(1) from sysobjects where xtype="P"
SELECT * FROM sysobjects WHERE (xtype = "U")
C = CHECK 約束
D = 預設值或 DEFAULT 約束
F = FOREIGN KEY 約束
L = 日誌
FN = 標量函式
IF = 內嵌表函式
P = 儲存過程
PK = PRIMARY KEY 約束(型別是 K)
RF = 複製篩選儲存過程
S = 系統表
TF = 表函式
TR = 觸發器
U = 使用者表
UQ = UNIQUE 約束(型別是 K)
V = 檢視
X = 擴充套件儲存過程