The sys.sysobjects system compatibility view contains one row for each object that is created within a database, such as functions, stored procedures, constraints, tables and views. One of the columns of the sys.sysobjects system view is the XTYPE which contains the type of object a particular row contains. The value in the XTYPE column can be one of the following object types:
- AF : Aggregate function (CLR)
- C : CHECK Constraint
- D : Default or DEFAULT Constraint
- F : FOREIGN KEY Constraint
- FN : Scalar Function
- FS : Assembly (CLR) Scalar-Function
- FT : Assembly (CLR) Table-Valued Function
- IF : In-lined Table Function
- IT : Internal Table
- L : Log
- P : Stored Procedure
- PC : Assembly (CLR) Stored Procedure
- PK : PRIMARY KEY Constraint (Type is K)
- RF : Replication Filter Stored Procedure
- S : System Table
- SN : Synonym
- SQ : Service Queue
- TA : Assembly (CLR) DML Trigger
- TF : Table Function
- TR : SQL DML Trigger
- TT : Table Type
- U : User Table
- UQ : UNIQUE Constraint
- V : View
- X : Extended Stored Procedure