ç¨æ·è¡¨å¨å½åæ°æ®åºçç³»ç»è¡¨ä¸ï¼å¯ä½¿ç¨ä»¥ä¸è¯å¥è¿è¡æ¥æ¾ï¼
select Name,ID from sysobjects where xtype='U'
è¥æ¯å°xtype='U'æ¢æxtype='V'å°±å¯ä»¥æ¥åºæ¥ææè§å¾
xtypeåæ°å¤§æ¦æ以ä¸ç§ç±»ï¼
C = CHECK 约æ
D = é»è®¤å¼æ DEFAULT 约æ
F = FOREIGN KEY 约æ
FN = æ éå½æ°
IF = å
åµè¡¨å½æ°
K = PRIMARY KEY æ UNIQUE 约æ
L = æ¥å¿
P = åå¨è¿ç¨
R = è§å
RF = å¤å¶çéåå¨è¿ç¨
S = ç³»ç»è¡¨
TF = 表å½æ°
TR = 触åå¨
U = ç¨æ·è¡¨
V = è§å¾
X = æ©å±åå¨è¿ç¨
温馨提示:答案为网友推荐,仅供参考