sys-system-objects-transact-sql.md

title	sys.system_objects (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	03/14/2017
ms.prod	sql-non-specified
ms.prod_service	database-engine, sql-database, sql-data-warehouse, pdw
ms.service
ms.component	system-catalog-views
ms.reviewer
ms.suite	sql
ms.technology	database-engine
ms.tgt_pltfrm
ms.topic	language-reference
f1_keywords	sys.system_objects system_objects system_objects_TSQL sys.system_objects_TSQL
dev_langs	TSQL
helpviewer_keywords	sys.system_objects catalog view
ms.assetid	069e9045-97f2-4463-8e8f-c73855f3ea0a
caps.latest.revision	32
author	edmacauley
ms.author	edmaca
manager	cguyer
ms.workload	Inactive

sys.system_objects (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-all-md]

Contains one row for all schema-scoped system objects that are included with [!INCLUDEmsCoName] [!INCLUDEssNoVersion]. All system objects are contained in the schemas named sys or INFORMATION_SCHEMA.

Column name	Data type	Description
name	sysname	Object name.
object_id	int	Object identification number. Is unique within a database.
principal_id	int	ID of the individual owner if different from the schema owner. By default, schema-contained objects are owned by the schema owner. However, another owner can be specified by using the ALTER AUTHORIZATION statement to change ownership. Is NULL if there is no other individual owner. Is NULL if the object type is one of the following: C = CHECK constraint D = DEFAULT (constraint or stand-alone) F = FOREIGN KEY constraint PK = PRIMARY KEY constraint R = Rule (old-style, stand-alone) TA = Assembly (CLR) trigger TR = SQL trigger UQ = UNIQUE constraint
schema_id	int	ID of the schema that the object is contained in. For all schema-scoped system objects that included with [!INCLUDEssNoVersion], this value will always be in (schema_id('sys'), schema_id('INFORMATION_SCHEMA'))
parent_object_id	int	ID of the object to which this object belongs. 0 = Not a child object.
type	char(2)	Object type: AF = Aggregate function (CLR) C = CHECK constraint D = DEFAULT (constraint or stand-alone) F = FOREIGN KEY constraint FN = SQL scalar function FS = Assembly (CLR) scalar-function FT = Assembly (CLR) table-valued function IF = SQL inline table-valued function IT = Internal table P = SQL Stored Procedure PC = Assembly (CLR) stored-procedure PG = Plan guide PK = PRIMARY KEY constraint R = Rule (old-style, stand-alone) RF = Replication-filter-procedure S = System base table SN = Synonym SQ = Service queue TA = Assembly (CLR) DML trigger TF = SQL table-valued-function TR = SQL DML trigger TT = Table type U = Table (user-defined) UQ = UNIQUE constraint V = View X = Extended stored procedure
type_desc	nvarchar(60)	Description of the object type. AGGREGATE_FUNCTION CHECK_CONSTRAINT DEFAULT_CONSTRAINT FOREIGN_KEY_CONSTRAINT SQL_SCALAR_FUNCTION CLR_SCALAR_FUNCTION CLR_TABLE_VALUED_FUNCTION SQL_INLINE_TABLE_VALUED_FUNCTION INTERNAL_TABLE SQL_STORED_PROCEDURE CLR_STORED_PROCEDURE PLAN_GUIDE PRIMARY_KEY_CONSTRAINT RULE REPLICATION_FILTER_PROCEDURE SYSTEM_TABLE SYNONYM SERVICE_QUEUE CLR_TRIGGER SQL_TABLE_VALUED_FUNCTION SQL_TRIGGER TABLE_TYPE USER_TABLE UNIQUE_CONSTRAINT VIEW EXTENDED_STORED_PROCEDURE
create_date	datetime	Date the object was created.
modify_date	datetime	Date the object was last modified by using an ALTER statement. If the object is a table or a view, modify_date also changes when a clustered index on the table or view is created or altered.
is_ms_shipped	bit	Object is created by an internal [!INCLUDEmsCoName] [!INCLUDEssNoVersion] component.
is_published	bit	Object is published.
is_schema_published	bit	Only the schema of the object is published.

Permissions

[!INCLUDEssCatViewPerm] For more information, see Metadata Visibility Configuration.

See Also

Catalog Views (Transact-SQL)
Object Catalog Views (Transact-SQL)