Tip of the Day : SQL Server 2012 Management Studio Keyboard Shortcuts - Help and Books Online

SQL Server Helper - Tip of the Day

Different XTYPE Values in the sys.sysobjects System View or dbo.sysobjects System Table

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