sys-sysobjects-transact-sql.md

title	sys.sysobjects (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	03/15/2017
ms.prod	sql
ms.prod_service	database-engine, sql-data-warehouse, pdw
ms.component	system-compatibility-views
ms.reviewer
ms.suite	sql
ms.technology	system-objects
ms.tgt_pltfrm
ms.topic	language-reference
f1_keywords	sys.sysobjects_TSQL sysobjects sysobjects_TSQL sys.sysobjects
dev_langs	TSQL
helpviewer_keywords	sys.sysobjects compatibility view sysobjects system table
ms.assetid	44fdc387-67b0-4139-8bf5-ed26cf640cd1
caps.latest.revision	41
author	rothja
ms.author	jroth
manager	craigg
monikerRange	>=aps-pdw-2016||=azure-sqldw-latest||>=sql-server-2016||=sqlallproducts-allversions||>=sql-server-linux-2017||=azuresqldb-mi-current

sys.sysobjects (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-xxxx-asdw-pdw-md]

Contains one row for each object that is created within a database, such as a constraint, default, log, rule, and stored procedure.

Important

[!INCLUDEssnoteCompView]

Column name	Data type	Description
name	sysname	Object name
id	int	Object identification number
xtype	char(2)	Object type. Can be one of the following object types: AF = Aggregate function (CLR) C = CHECK constraint D = Default or DEFAULT constraint F = FOREIGN KEY constraint L = Log FN = Scalar function FS = Assembly (CLR) scalar-function FT = Assembly (CLR) table-valued function IF = In-lined table-function IT = Internal table 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 (type is K) V = View X = Extended stored procedure
uid	smallint	Schema ID of the owner of the object. For databases upgraded from an earlier version of [!INCLUDEssNoVersion], the schema ID is equal to the user ID of the owner. Overflows or returns NULL if the number of users and roles exceeds 32,767. ** Important ** If you use any of the following [!INCLUDEssNoVersion] DDL statements, you must use the sys.objects catalog view instead of sys.sysobjects. CREATE | ALTER | DROP USER CREATE | ALTER | DROP ROLE CREATE | ALTER | DROP APPLICATION ROLE CREATE SCHEMA ALTER AUTHORIZATION ON OBJECT
info	smallint	[!INCLUDEssInternalOnly]
status	int	[!INCLUDEssInternalOnly]
base_schema_ver	int	[!INCLUDEssInternalOnly]
replinfo	int	[!INCLUDEssInternalOnly]
parent_obj	int	Object identification number of the parent object. For example, the table ID if it is a trigger or constraint.
crdate	datetime	Date the object was created.
ftcatid	smallint	Identifier of the full-text catalog for all user tables registered for full-text indexing, and 0 for all user tables that are not registered.
schema_ver	int	Version number that is incremented every time the schema for a table changes. Always returns 0.
stats_schema_ver	int	[!INCLUDEssInternalOnly]
type	char(2)	Object type. Can be one of the following values: 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 functionIF = In-lined table-function IT - Internal table K = PRIMARY KEY or UNIQUE constraint L = Log P = Stored procedure PC = Assembly (CLR) stored-procedure R = Rule 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 V = View X = Extended stored procedure
userstat	smallint	[!INCLUDEssInternalOnly]
sysstat	smallint	[!INCLUDEssInternalOnly]
indexdel	smallint	[!INCLUDEssInternalOnly]
refdate	datetime	[!INCLUDEssInternalOnly]
version	int	[!INCLUDEssInternalOnly]
deltrig	int	[!INCLUDEssInternalOnly]
instrig	int	[!INCLUDEssInternalOnly]
updtrig	int	[!INCLUDEssInternalOnly]
seltrig	int	[!INCLUDEssInternalOnly]
category	int	Used for publication, constraints, and identity.
cache	smallint	[!INCLUDEssInternalOnly]

See Also

Mapping System Tables to System Views (Transact-SQL)
Compatibility Views (Transact-SQL)