Skip Navigation Links
Home
Articles
SQL Server 2012
SQL Server 2014
SQL Server 2016
FAQ
Forums
Practice Test
Bookstore
Tip of the Day : Fixed Server Roles
SQL Server Helper
Home > > Tip of the Day
SQL Server Helper - Tip of the Day

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

Back to Tip of the Day List Next Tip