sql server 查詢資料庫中有多少個表

 

 

SELECT * FROM sysobjects WHERE (xtype = 'U')

SELECT * FROM sysobjects WHERE (xtype = 'U')

SELECT * FROM sysobjects WHERE (xtype = 'C')

SELECT * FROM sysobjects WHERE (xtype = 'D')

SELECT * FROM sysobjects WHERE (xtype = 'F')

SELECT * FROM sysobjects WHERE (xtype = 'L')

 SELECT * FROM sysobjects WHERE (xtype = 'FN')

SELECT * FROM sysobjects WHERE (xtype = 'IF')

SELECT * FROM sysobjects WHERE (xtype = 'P')

SELECT * FROM sysobjects WHERE (xtype = 'PK')

SELECT * FROM sysobjects WHERE (xtype = 'RF')

SELECT * FROM sysobjects WHERE (xtype = 'S')

SELECT * FROM sysobjects WHERE (xtype = 'TR')

SELECT * FROM sysobjects WHERE (xtype = 'U')

SELECT * FROM sysobjects WHERE (xtype = 'UQ')

SELECT * FROM sysobjects WHERE (xtype = 'V')

SELECT * FROM sysobjects WHERE (xtype = 'X')

  --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 = 擴充預存程序