sql server 2005で1つのデータベースに何枚のテーブルがあるかをクエリー
534 ワード
sql server 2005で1つのデータベースに何枚のテーブルがあるかをクエリー
SELECT * FROM sysobjects WHERE (xtype = 'U')SELECT COUNT(*) FROM sysobjects WHERE (xtype = 'U')
SELECT * FROM sysobjects WHERE (xtype = 'U')SELECT COUNT(*) FROM sysobjects WHERE (xtype = 'U')
xtype = 'U' :xtype char(2) 。 :
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 =