sys.system_objects (Transact-SQL)sys.system_objects (Transact-SQL)
SQL Server Azure SQL Database Azure Synapse Analytics (SQL DW) 平行處理資料倉儲 SQL Server Azure SQL Database Azure Synapse Analytics (SQL DW) Parallel Data Warehouse
包含所有結構描述範圍系統物件所包含的一個資料列MicrosoftMicrosoft SQL ServerSQL Server。Contains one row for all schema-scoped system objects that are included with MicrosoftMicrosoft SQL ServerSQL Server. 所有系統物件都包含在名稱為 sys 或 INFORMATION_SCHEMA 的結構描述中。All system objects are contained in the schemas named sys or INFORMATION_SCHEMA.
| 資料行名稱Column name | 資料類型Data type | 描述Description |
|---|---|---|
| namename | sysnamesysname | 物件名稱。Object name. |
| object_idobject_id | intint | 物件識別碼。Object identification number. 在資料庫中，這是唯一的。Is unique within a database. |
| principal_idprincipal_id | intint | 如果個別擁有者不是結構描述擁有者，這便是個別擁有者的識別碼。ID of the individual owner if different from the schema owner. 依預設，結構描述包含的物件就是結構描述擁有者所擁有的物件。By default, schema-contained objects are owned by the schema owner. 不過，您也可以利用 ALTER AUTHORIZATION 陳述式來變更擁有權，指定另一個擁有者。However, another owner can be specified by using the ALTER AUTHORIZATION statement to change ownership. 如果沒有其他個別擁有者，便是 NULL。Is NULL if there is no other individual owner. 如果物件類型是下列其中一項，便是 NULL：Is NULL if the object type is one of the following: C = CHECK 條件約束C = CHECK constraint D = DEFAULT (條件約束或獨立式)D = DEFAULT (constraint or stand-alone) F = FOREIGN KEY 條件約束F = FOREIGN KEY constraint PK = PRIMARY KEY 條件約束PK = PRIMARY KEY constraint R = 規則 (舊式、獨立式)R = Rule (old-style, stand-alone) TA = 組件 (CLR) 觸發程序TA = Assembly (CLR) trigger TR = SQL 觸發程序TR = SQL trigger UQ = UNIQUE 條件約束UQ = UNIQUE constraint |
| schema_idschema_id | intint | 物件所在的結構描述識別碼。ID of the schema that the object is contained in. 對於 SQL ServerSQL Server 所包括的所有結構描述範圍系統物件而言，這個值一律會在 (schema_id('sys'), schema_id('INFORMATION_SCHEMA')) 中For all schema-scoped system objects that included with SQL ServerSQL Server, this value will always be in (schema_id('sys'), schema_id('INFORMATION_SCHEMA')) |
| parent_object_idparent_object_id | intint | 這個物件所屬的物件識別碼。ID of the object to which this object belongs. 0 = 不是子物件。0 = Not a child object. |
| typetype | char(2)char(2) | 物件類型：Object type: AF = 彙總函式 (CLR)AF = Aggregate function (CLR) C = CHECK 條件約束C = CHECK constraint D = DEFAULT (條件約束或獨立式)D = DEFAULT (constraint or stand-alone) F = FOREIGN KEY 條件約束F = FOREIGN KEY constraint FN = SQL 純量函數FN = SQL scalar function FS = 組件 (CLR) 純量函數FS = Assembly (CLR) scalar-function FT = 組件 (CLR) 資料表值函式FT = Assembly (CLR) table-valued function IF = SQL 嵌入資料表值函式IF = SQL inline table-valued function IT = 內部資料表IT = Internal table P = SQL 預存程序P = SQL Stored Procedure PC = 組件 (CLR) 預存程序PC = Assembly (CLR) stored-procedure PG = 計畫指南PG = Plan guide PK = PRIMARY KEY 條件約束PK = PRIMARY KEY constraint R = 規則 (舊式、獨立式)R = Rule (old-style, stand-alone) RF = 複寫篩選程序RF = Replication-filter-procedure S = 系統基底資料表S = System base table SN = 同義字SN = Synonym SQ = 服務佇列SQ = Service queue TA = 組件 (CLR) DML 觸發程序TA = Assembly (CLR) DML trigger TF = SQL 資料表值函式TF = SQL table-valued-function TR = SQL DML 觸發程序TR = SQL DML trigger TT = 資料表類型TT = Table type U = 資料表 (使用者定義)U = Table (user-defined) UQ = UNIQUE 條件約束UQ = UNIQUE constraint V = 檢視V = View X = 擴充預存程序X = Extended stored procedure |
| type_desctype_desc | nvarchar(60)nvarchar(60) | 物件類型的描述。Description of the object type. AGGREGATE_FUNCTIONAGGREGATE_FUNCTION CHECK_CONSTRAINTCHECK_CONSTRAINT DEFAULT_CONSTRAINTDEFAULT_CONSTRAINT FOREIGN_KEY_CONSTRAINTFOREIGN_KEY_CONSTRAINT SQL_SCALAR_FUNCTIONSQL_SCALAR_FUNCTION CLR_SCALAR_FUNCTIONCLR_SCALAR_FUNCTION CLR_TABLE_VALUED_FUNCTIONCLR_TABLE_VALUED_FUNCTION SQL_INLINE_TABLE_VALUED_FUNCTIONSQL_INLINE_TABLE_VALUED_FUNCTION INTERNAL_TABLEINTERNAL_TABLE SQL_STORED_PROCEDURESQL_STORED_PROCEDURE CLR_STORED_PROCEDURECLR_STORED_PROCEDURE PLAN_GUIDEPLAN_GUIDE PRIMARY_KEY_CONSTRAINTPRIMARY_KEY_CONSTRAINT RULERULE REPLICATION_FILTER_PROCEDUREREPLICATION_FILTER_PROCEDURE SYSTEM_TABLESYSTEM_TABLE SYNONYMSYNONYM SERVICE_QUEUESERVICE_QUEUE CLR_TRIGGERCLR_TRIGGER SQL_TABLE_VALUED_FUNCTIONSQL_TABLE_VALUED_FUNCTION SQL_TRIGGERSQL_TRIGGER TABLE_TYPETABLE_TYPE USER_TABLEUSER_TABLE UNIQUE_CONSTRAINTUNIQUE_CONSTRAINT VIEWVIEW EXTENDED_STORED_PROCEDUREEXTENDED_STORED_PROCEDURE |
| create_datecreate_date | datetimedatetime | 物件的建立日期。Date the object was created. |
| modify_datemodify_date | datetimedatetime | 上次利用 ALTER 陳述式來修改物件的日期。Date the object was last modified by using an ALTER statement. 如果物件是資料表或檢視，當建立或變更資料表或檢視的叢集索引時，也會變更 modify_date。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_shippedis_ms_shipped | bitbit | 物件由內部MicrosoftMicrosoftSQL ServerSQL Server元件。Object is created by an internal MicrosoftMicrosoft SQL ServerSQL Server component. |
| is_publishedis_published | bitbit | 已發行物件。Object is published. |
| is_schema_publishedis_schema_published | bitbit | 僅發行物件的結構描述。Only the schema of the object is published. |
PermissionsPermissions
目錄檢視內中繼資料的可見性會限制在使用者所擁有的安全性實體，或已授與使用者某些權限的安全性實體。The visibility of the metadata in catalog views is limited to securables that a user either owns or on which the user has been granted some permission. 如需相關資訊，請參閱 Metadata Visibility Configuration。For more information, see Metadata Visibility Configuration.
另請參閱See Also
目錄檢視 (Transact-SQL) Catalog Views (Transact-SQL)
物件目錄檢視(Transact SQL)Object Catalog Views (Transact-SQL)
意見反應
正在載入意見反應...