T-SQL：系统对象 SYSOBJECTS.XTYPE 各个值的含意

 

SQL SERVER 2008R2 系统对象 SYSOBJECTS.XTYPE  共有16个值，

分别是：

 SELECT DISTINCT AO.TYPE AS XTYPE, AO.TYPE_DESC FROM SYS.all_objects  AO


XTYPE TYPE_DESC
----- ------------------------------------------------------------
FN    SQL_SCALAR_FUNCTION
SO    SEQUENCE_OBJECT
IF    SQL_INLINE_TABLE_VALUED_FUNCTION
UQ    UNIQUE_CONSTRAINT
SQ    SERVICE_QUEUE
U     USER_TABLE
FS    CLR_SCALAR_FUNCTION
PK    PRIMARY_KEY_CONSTRAINT
V     VIEW
AF    AGGREGATE_FUNCTION
S     SYSTEM_TABLE
IT    INTERNAL_TABLE
P     SQL_STORED_PROCEDURE
X     EXTENDED_STORED_PROCEDURE
TF    SQL_TABLE_VALUED_FUNCTION
PC    CLR_STORED_PROCEDURE