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
标签：FUNCTION,XTYPE,STORED,SQL,TABLE,PROCEDURE,SYSOBJECTS From： https://www.cnblogs.com/samrv/p/17068138.html