System Catalog Views

Shows the union of all columns belonging to user-defined objects and system objects.

Shows the UNION of all schema-scoped user-defined objects and system objects.

Shows the union of all parameters that belong to user-defined or system objects.

The view returns a row for each natively compiled, scalar user-defined function. For more Scalar User-Defined Functions for In-Memory OLTP ID of the object of the containing object.

Shows the UNION of all user-defined and system views. For a list of columns that this view inherits, see 1 = View has a replication filter. 1 = VIEW_METADATA option specified for view. For more 1 = Table contains persisted data that depends on an assembly whose definition changed during the last ALTER ASSEMBLY. Resets to 0 after the next successful DBCC CHECKDB or D

Contains a row for each allocation unit in the database.

SQL analytics endpoint in Microsoft Fabric Returns a row for each assembly.

Contains a row for each file that makes up an assembly.

SQL analytics endpoint in Microsoft Fabric Returns one row for each function, procedure or trigger that is defined by a common language runtime (CLR) assembly. This catalog view maps CLR stored procedures, CLR triggers, or CLR functions to their underlying implementation. Objects of type TA, AF, PC, FS, and FT have an associated assembly module. To find the associat

Contains a row for each pair of assemblies where one is directly referencing another.

SQL analytics endpoint in Microsoft Fabric Contains a row for each user-defined type that is defined by a CLR assembly. The following appear in the list of inherited columns (see ID of the assembly from which this type was created.

Returns one row for each availability database on the instance of SQL Server that hosts an availability replica for any Always On availability group in the Windows Server Failover Clustering (WSFC) cluster, regardless of whether the local copy database has been joined to the Unique identifier of the availability group in which the database NULL = database isn't part of an availability replica in a

Returns a row for every IP address that is associated with any Always On availability group listener in the Windows Server Failover Clustering (WSFC) cluster. Resource GUID from Windows Server Failover Clustering Configured virtual IP address of the availability group listener. Returns a single IPv4 or IPv6 address.

For each Always On availability group, returns either zero rows indicating that no network name is associated with the availability group, or returns a row for each availability-group listener configuration in the Windows Server Failover Clustering (WSFC) cluster. This view displays the real-time configuration gathered from cluster. GUID from the cluster resource ID. Configured network name (hostn

Returns a row for each availability group where the local instance of SQL Server hosts an availability replica. Each row contains a cached copy of the availability group metadata. Unique identifier (GUID) of the Name of the availability group.

Returns a row for each Always On availability group in Windows Server Failover Clustering (WSFC). Each row contains the availability group metadata from the WSFC cluster. Unique identifier (GUID) of the availability group.

Returns a row for the read-only routing list of each availability replica in an Always On availability group in the WSFC failover cluster. Unique ID of the availability replica that owns the routing list. Priority order for routing (1 is first, 2 is second, and so forth). Unique ID of the availability replica to which a read-only The visibility of the metadata in catalog views is limited to secura

Returns a row for each of the availability replicas that belong to any Always On availability groups in the Windows Server Failover Cluster (WSFC). If the local server instance can't connect to the WSFC failover cluster, for example because the cluster is down or quorum is lost, availability replicas. These rows contain only the columns of data that are cached locally in Unique ID of the availabil

105 = A permanent backup device. All permanent device names and device numbers can be Physical block size used to write the media family.

Returns a row for each certificate in the database.

Returns one row for each table in the current database that has change tracking enabled.

Contains a row for each object that is a CHECK constraint, with For a list of columns that this view inherits, see CHECK constraint was created with the NOT FOR CHECK constraint has not been verified by the system for 0 indicates a table-level CHECK constraint. Non-zero value indicates that this is a column-level CHECK constraint defined on the column with the SQL

Returns information about encrypted values of column encryption keys (CEKs) created with statement. Each row represents a value of a CEK, encrypted with a column ID of the CEK in the database.

2016 (13.x) and later versions Analytics Platform System (PDW) Returns information about column encryption keys (CEKs) created with the statement. Each row represents a CEK. Date the CEK was last modified. The visibility of the metadata in catalog views is limited to securables that a user either owns, or on which the user was granted some permission. For more information, see CREATE CO

2016 (13.x) and later Returns a row for each database master key added by using the statement. Each row represents a single column master key (CMK). Date the column master key was created. Date the column master key was last modified.

2012 (11.x) and later Contains a row for each dictionary used in xVelocity memory optimized columnstore indexes. Dictionaries are used to encode some, but not all data types, therefore not all columns in a columnstore index have dictionaries. A dictionary can exist as a primary dictionary (for all segments) and possibly for other secondary dictionaries used for a subset of the column's

Provides columnstore index information on a per-segment basis. For clustered columnstore indexes, number of rows physically stored (including those marked as deleted) and a column for the number of rows marked as deleted. Use groups have a high percentage of deleted rows and should be rebuilt. The ID of the table on which this index is defined. The ID of the column

Returns one row for each column segment in a columnstore index. There is one column segment per column per rowgroup. For example, a columnstore index with 10 rowgroups and 34 columns has 340 rows in this view. Indicates the partition ID.

Contains one row for each column that is of user-defined type.

Returns a row for each column that is validated by an XML schema. The ID of the object to which this column belongs. The ID of the column.

Returns a row for each column of an object that has columns, such as views or tables. The following list contains the object types that have columns: Table-valued assembly functions (FT) Inline table-valued SQL functions (IF) Table-valued SQL functions (TF) ID of the object to which this column belongs.

Contains a row for each column found in view returns all columns in the view. It also returns the additional columns described below. For a description of the columns that the column is always set to 1 in the SQL text that defines this computed-column. 1 = The column definition depends on the default collation of the database for correct evaluation; otherwise, 0. Su

Returns a row for each server-wide configuration option value in the system. Unique ID for the configuration value.

Each side of a Service Broker conversation is represented by a conversation endpoint. This catalog view contains a row per conversation endpoint in the database. Identifier for this conversation endpoint. Not Identifier for the conversation. This identifier is shared by both participants in the conversation. This together with the is_initiator column is unique within the database. Not NULLABLE. Wh

This catalog view contains a row for each conversation group. Identifier for the conversation group. Not NULLABLE.

Contains a row for each conversation priority created in the current database, as shown in the A number that uniquely identifies the conversation priority. Not Name of the conversation priority. Not NULLABLE. The identifier of the contract that is specified for the conversation priority. This can be joined on the service_contract_id column in sys.service_contracts. NULLABLE.

Returns one row for each server-level credential.

The password that is required to decrypt the private key of the certificate or asymmetric key. This clause is only required if the private key isn't protected by the database master key. Specifies the signed, binary large object (BLOB) of the module. This clause is useful if you want to ship a module without shipping the private key. When you use this clause, only the module, signature, and public

Returns one row for each registered cryptographic provider. Identification number of the cryptographic provider.

SQL analytics endpoint in Microsoft Fabric Contains a row for each data space. This can be a filegroup, partition scheme, or FILESTREAM Name of data space, unique within the database. Data space ID number, unique within the database. FD = FILESTREAM data filegroup FX = Memory-optimized tables filegroup : SQL Server 2014 (12.x) and later.

Contains information about the database audit specifications in a SQL Server audit on a server instance for all databases. For more information, see SQL Server Audit (Database Engine) list of all audit_action_id's and their names, query sys.dm_audit_actions (Transact-SQL) ID of the audit specification.

This article contains information about the database audit specifications in a SQL Server audit on a server instance. For more information, see SQL Server Audit (Database Engine) Name of the auditing specification.

2017 (14.x) and later versions SQL database in Microsoft Fabric Returns the automatic tuning mode for this database. Refer to AUTOMATIC_TUNING (Transact-SQL) Desired state of the automatic tuning mode. Textual description of the desired operation mode of automatic Indicates the operation mode of automatic tuning mode. Textual description of the actual operation mode of automatic ALTER D

2017 (14.x) and later versions SQL database in Microsoft Fabric Returns the automatic tuning options for this database.

2016 (13.x) and later versions SQL database in Microsoft Fabric Returns one row for each database scoped credential in the database.

2016 (13.x) and later versions Azure SQL Database Azure SQL Managed SQL database in Microsoft Fabric dynamic management view (DMV) returns a row for each action on each event of a database-scoped event session. For information on actions in database-scoped event sys.dm_xe_database_session_event_actions Azure SQL Database and SQL database in Fabric support only database-scoped sessions A

2016 (13.x) and later versions Azure SQL Database Managed Instance SQL database in Microsoft Fabric dynamic management view (DMV) returns a row for each event in a database-scoped event session. For information on events in database-scoped sessions, see sys.dm_xe_database_session_events Azure SQL Database and SQL database in Fabric support only database-scoped sessions Azure SQL Managed

2016 (13.x) and later versions Azure SQL Database Azure SQL Managed SQL database in Microsoft Fabric dynamic management view (DMV) returns a row for each customizable column that was explicitly set on in a database-scoped event session.

2016 (13.x) and later versions Azure SQL Database Managed Instance SQL database in Microsoft Fabric dynamic management view (DMV) returns a row for each event target for a database-scoped event session.

Contains a row per file of a database as stored in the database itself. This is a per-database ID of the file within database. = Database was upgraded from an earlier version of SQL Server (Valid for SQL Server 2005 and earlier 3 = Identified for informational purposes only. Not supported. Future compatibility is not guaranteed.

Displays information about the level of non-transactional access to FILESTREAM data in FileTables that is enabled. Contains one row for each database in the SQL Server instance. For more information about FileTables, see The ID of the database. This value is unique within the The database-level directory for all FileTable namespaces.

Captures the cryptographically chained blocks, each of which represents a block of transactions For more information on database ledger, see A sequence number identifying the row in this view. The hash of the root of the Merkle tree, formed by transactions The number of transactions in the block. A SHA-256 hash of the previous row in the view.

Captures the current and the historical ledger digest storage endpoints for the ledger feature. For more information on database ledger, see The location of storage digests. For example, a path for a The block ID for the last digest uploaded. Indicates whether this is the current path or a path used in the Configure automatic database digests

Captures the cryptographically protected history of database transactions against ledger tables in the database. A row in this view represents a database transaction. For more information on database ledger, see A transaction ID that is unique for the database (it corresponds to a transaction ID in the database transaction log). A sequence number identifying a row.

Returns one row for each database in the instance of SQL Server. If the database isn't ONLINE or database mirroring isn't enabled, the values of all columns except database_id are NULL.

Returns one row for the database mirroring endpoint of an instance of SQL Server. Note: This value is relevant only for database mirroring. Description of mirroring role, one of: Note: This value is relevant only for database mirroring. The database mirroring endpoint supports both sessions between database mirroring partners and with witnesses and sessions between the primary replica of an Always

Contains a row for every witness role that a server plays in a database mirroring partnership. In a database mirroring session, automatic failover requires a witness server. Ideally, the witness resides on a separate computer from both the principal and mirror servers. The witness does not serve the database. Instead, it monitors the status of the principal and mirror servers.

Returns a row for every permission or column-exception permission in the database. For columns, there is a row for every permission that is different from the corresponding object- level permission. If the column permission is the same as the corresponding object permission, there is no row for it and the permission applied is that o

Returns a row for each security principal in a SQL Server database.

2025 (17.x) Azure SQL Database Contains information about queue length and memory usage for the Query Store when the Query Store for secondary replicas is enabled. Query Store for secondary replicas is supported starting in SQL Server 2025 (17.x) and later versions, and in Azure SQL Database.

2016 (13.x) and later versions SQL database in Microsoft Fabric Returns the Query Store options for this database. Indicates the desired operation mode of Query Store, explicitly set by user. Textual description of the desired operation mode of Query Store: Indicates the operation mode of Query Store.

Contains one row per database. If the database is not opened, the SQL Server Database Engine To see the row for a database other than , one of the following must apply: Have ALTER ANY DATABASE or VIEW ANY DATABASE server-level permissions. Have CREATE DATABASE permission in the ID of the database, unique within an instance of SQL Server. Used to relate all the database files of a database together

Returns one row for each member of each database role. Database users, application roles, and other database roles can be members of a database role. To add members to a role, use the Database principal ID of the role. Database principal ID of the member. Any user can view their own role membership.

2016 (13.x) and later versions Azure SQL Database SQL Managed Instance Azure Synapse Analytics SQL analytics endpoint in Microsoft Warehouse in Microsoft Fabric SQL database in Microsoft Fabric Contains one row per configuration.

2016 (13.x) and later versions SQL database in Microsoft Fabric Returns one row for each database scoped credential in the database.

Lists databases that either reside in an instance of the SQL Server or are accessible through a database gateway.

Contains a row for each object that is a default definition (created as part of a CREATE TABLE or ALTER TABLE statement instead of a CREATE DEFAULT statement), with For a list of columns that this view inherits, see SQL expression that defines this default. 1 = Name was generated by system. 0 = Name was supplied by the user.

Contains a row for each data space destination of a partition scheme.

This feature will be removed in a future version of SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature. Returns a row for each SOAP method defined on a SOAP-enabled HTTP endpoint. The combination of the endpoint_id and namespace columns is unique.

Returns one row per endpoint created in the system. There's always exactly one SYSTEM Name of the endpoint. Unique within the server. Not nullable.

Returns a row for each event or event group on which an event notification can fire. Type of event or event group that causes an event notification to fire.

Returns a row for each object that is an event notification, with Object identification number.

The name of a predefined group of Transact-SQL or SQL Trace event types. An event notification can fire after execution of any event that belongs to an event group. For a list of DDL event groups, the Transact-SQL events they cover, and the scope at which they can be DDL Event Groups also acts as a macro, when the statement finishes, by adding the event types it covers to the Specifies the target

Contains a row for each object that is an extended stored procedure, with . Because extended stored procedures are installed into the database, they're only visible from that database context. Selecting from the view in any other database context returns an empty result set.

Returns a row for each extended property in the current database. Identifies the class of item on which the property exists.

2016 (13.x) and later versions Analytics Platform System (PDW) SQL database in Microsoft Fabric Contains a row for each external data source in the current database for SQL Server, Azure SQL Database, and Azure Synapse Analytics. Contains a row for each external data source on the server for Analytics Platform System Object ID for the external data Data source type displayed as a Data s

2016 (13.x) and later Azure SQL Database Managed Instance Azure Synapse Analytics Analytics Platform System (PDW) Removes a PolyBase external file format.

This catalog view provides a list of the external language extension files in the database. are reserved names and no external language can be created with those specific When an external language is created from a file_spec, the extension itself and its properties are listed in this view. This view will contain one entry per language, per OS. The catalog view sys.external_language_files lists a r

This catalog view provides a list of the external languages in the database. reserved names and no external language can be created with those specific names. The catalog view sys.external_languages lists a row for each external language in the database.

2017 (14.x) and later versions Azure SQL Managed Instance catalog view supports the management of package libraries related to external runtimes such as R, Python, and Java. lists a row for each external library that is uploaded into the database.

2017 (14.x) and later Lists a row for each file that makes up an external library.

Contains a row for each external model in the current database.

2016 (13.x) and later versions Analytics Platform System (PDW) SQL database in Microsoft Fabric Contains a row for each external table in the current database. For a list of columns that this view inherits, Maximum column ID ever used for this table. Object ID for the external data source. For external tables over a HADOOP external For external tables over a HADOOP external data source,

Contains a row for each data space that is a filegroup. For a list of columns that this view inherits, see Identified for informational purposes only. Not supported. Future compatibility is not guaranteed. In SQL Server, the value SQL Server 2016 (13.x) and later versions. 1 = When a file in the filegroup meets the autogrow threshold

Displays a list of the system-defined objects that are related to FileTables. Contains one row for When you create a FileTable, related objects such as constraints and indexes are created at the same time. You cannot alter or drop these objects; they disappear only when the FileTable itself For more information about FileTables, see Object ID of the system-defined object related to a FileTable. Ob

Returns a row for each FileTable in SQL Server. For more information about FileTables, see Object identification number.

Contains a row for each column, or set of columns, that comprise a foreign key.

Contains a row per object that is a FOREIGN KEY constraint, with For a list of columns that this view inherits, see ID of the key index within the referenced object. FOREIGN KEY constraint is disabled. FOREIGN KEY constraint was created by using the FOREIGN KEY constraint has not been verified by the The referential action that was d

Contains a row for each full-text catalog.

Returns a row for each document type that is available for full-text indexing operations. Each row represents the IFilter interface that is registered in the instance of SQL Server. The file extension of the supported document type. This value can be used to identify the filter that will be used during full-text indexing of columns of type GUID of the IFilter class that supports file extension. Th

Returns a row for each full-text catalog to full-text index reference.

'Contains a row for each column that is part of a full-text index. ID of the object of which this is part. ID of the column that is part of the full-text index. ID of the type column that stores the user-supplied document file extension-".doc", ".xls", and so forth-of the document in a given row. The type column is specified only for columns whose data requires filtering during full-text indexing. '

A fulltext index uses internal tables called full-text index fragments to store the inverted index data. This view can be used to query the metadata about these fragments. This view contains a row for each full-text index fragment in every table that contains a full-text index. Object ID of the table that contains the full-text index fragment. fragment

Contains a row per full-text index of a tabular object.

This catalog view contains one row per language whose word breakers are registered with SQL Server. Each row displays the LCID and name of the language. When word breakers are registered for a language, its other linguistic resources (such as , and thesaurus files) become available to full-text indexing/querying operations.

The following example shows how to query to get information about the semantic language statistics database registered on the current instance of SQL Server. Install and Configure Semantic Search

Returns a row for each language whose statistics model is registered with the instance of SQL Server. When a language model is registered, that language is enabled for semantic indexing. This catalog view is similar to sys.fulltext_languages (Transact-SQL) Microsoft Windows locale identifier (LCID) for the language.

Contains a row per full-text stoplist in the database.

Contains a row per stopword for all stoplists in the database. belongs. This ID is unique within the The term to be considered for a stop-word match.

Provides access to the system stoplist. The term that is considered for a stop-word match. Locale identifier (LCID) of the language. This LCID is used for word The visibility of the metadata in catalog views is limited to securables that a user either owns, or on which the user was granted some permission. Object Catalog Views (Transact-SQL) sys.fulltext_stoplists (Transact-SQL) sys.fulltext_stopw

Returns one row per column that is a part of an expression of a common language runtime (CLR) table-valued function.

2014 (12.x) and later Shows the current hash indexes and the hash index properties. Hash indexes are supported In-Memory OLTP (In-Memory Optimization) The sys.hash_indexes view contains the same columns as the sys.indexes view and an additional . For more information about the other columns in the Count of hash buckets for hash indexes. For more information about the bucket_count value,

This feature will be removed in a future version of SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature. Returns a row for each endpoint created in the server that uses the HTTP protocol.

Contains a row for each column that is an identity column. view returns the columns in the columns. For more information, see view returns all columns in the view. It also returns the additional columns described below. For a description of the columns that the Seed value for this identity column. The data type of the seed value is the same as the data type of the c

Contains one row per column that is part of an index or unordered table (heap).

2017 (14.x) and later versions SQL database in Microsoft Fabric is a system view that monitors and checks the current execution status for resumable Index rebuild or creation. : SQL Server (2017 and newer), and Azure SQL Database ID of the object to which this index belongs (not nullable).

The percentage of space on each index page for storing data when the index is created or replaces the fill factor when the index was created, becoming the new default for the index and for any other nonclustered indexes rebuilt, because a clustered index is uses the fill factor value last specified for the index. This value is stored in the must be specified. If isn't specified, the default fill f

2016 (13.x) and later versions SQL database in Microsoft Fabric Returns one row for each rowset that tracks internal data for columnstore indexes on disk- based tables. These rowsets are internal to columnstore indexes and track deleted rows, rowgroup mappings, and delta store rowgroups. They track data for each table partition. Every table has at least one partition. The Database Engin

Returns one row for each object that is an internal table. Internal tables are automatically generated by SQL Server to support various features. For example, when you create a primary XML index, SQL Server automatically creates an internal table to persist the shredded XML document data. Internal tables appear in the schema of every database and have unique, system-generated names that indicate t

2025 (17.x) Preview Contains the SQL/JSON paths for a JSON index. If the , this catalog view contains one row with a root SQL/JSON path SQL/JSON path. Collation of the path column is fixed to The visibility of the metadata in catalog views is limited to securables that a user either owns, or on which the user was granted some permission. For more information, see The following example r

2025 (17.x) Preview Contains a row per json index. Indicates that array search optimization is enabled for JSON index. 1 = Array search optimization is enabled for JSON index. 0 = Array search optimization isn't enabled for JSON indexes. The visibility of the metadata in catalog views is limited to securables that a user either owns, or on which the user was granted some permission. For

Contains a row for each object that is a primary key or unique constraint. Includes For a list of columns that this view inherits, see ID of the corresponding unique index in the parent object that was created to enforce this constraint. 1 = Name was generated by system. 0 = Name was supplied by the user. The visibility of the metada

Returns a row for each symmetric key encryption specified by using the To protect the key material of the symmetric key, SQL Server and Azure SQL store the key material in encrypted form. Historically, this encryption utilized PKCS#1 v1.5 padding mode; starting with database compatibility level 170, the encryption uses OAEP-256 padding mode.

Captures the cryptographically protected history of operations on columns of ledger tables: adding, renaming, and dropping columns. For more information on database ledger, see The object ID of the ledger table. The column ID of the column in a ledger table.

Captures the cryptographically protected history of operations on ledger tables: creating ledger tables, renaming ledger tables or ledger views, and dropping ledger tables. For more information on database ledger, see The object ID of the ledger table.

Returns a row per linked-server-login mapping, for use by RPC and distributed queries from local server to the corresponding linked server. Server-principal to whom mapping applies. If 1, mapping indicates session should use its own credentials; otherwise, 0 indicates that session uses the name and password that Remote user name to use when connecting. Password is also stored, but not exposed in c

Returns one row for every server principal that is part of the login token.

2016 (13.x) and later versions SQL database in Microsoft Fabric view to query for table-columns that have a dynamic data masking function applied to them. This view inherits from the indicating if the column is masked, and if so, what masking function is defined. This view only shows the columns on which there is a masking function applied.

Contains a row per file of a database as stored in the ID of the database to which this file applies. The ID of the file within database. The primary Unique identifier of the file. = Database was upgraded from an earlier version of SQL Server (Valid for SQL Server 2005 (9.x) and earlier = Identified for informational purposes only. Not supported. Future compatibility is not guaranteed. = Full-text

Returns a row for each database master key password added by using the stored procedure. The passwords that are used to protect the master keys are stored in the credential store. The credential name follows this format: ##DBMKEY_<database_family_guid>_<random_password_guid>##. The password is stored as the credential secret. For each password added by using of which is protected by the password a

No description available.

Contains information about all available SQL Server Agent proxy subsystems. The table is stored in the ID of the subsystem.

Returns a row for each module-to-assembly reference.

Contains one row for each parameter of a numbered procedure. When you create a numbered stored procedure, the base procedure is number 1. All subsequent procedures have numbers 2, contains the parameter definitions for all subsequent procedures, numbered 2 and greater. This view does not show parameters for the base stored procedure (number = 1). The base stored procedure is similar to a nonnumber

SQL analytics endpoint in Microsoft Fabric Contains a row for each SQL Server stored procedure that was created as a numbered procedure. This does not show a row for the base (number = 1) stored procedure. Entries for the base stored procedures can be found in views such as ID of the object of the stored procedure.

SQL analytics endpoint in Microsoft Fabric Warehouse in Microsoft Fabric SQL database in Microsoft Fabric Catalog views return information that is used by the SQL Server Database Engine.

This catalog view returns information about encryption keys that are open in the current ID of the database that contains the key.

Returns one row for each parameter that is of user-defined type.

Contains a row for each parameter of an object that accepts parameters. If the object is a scalar function, there's also a single row describing the return value. That row has a ID of the object to which this parameter belongs.

Contains a row for each partition function in SQL Server.

Contains a row for each parameter of a partition function.

Contains a row for each range boundary value of a partition function of type R.

SQL analytics endpoint in Microsoft Fabric Contains a row for each Data Space that is a partition scheme, with sys.data_spaces (Transact-SQL) ID of partition function used in the scheme. For a list of columns that this view inherits, see sys.data_spaces (Transact-SQL) role. For more information, see Querying the SQL Server System Catalog FAQ

Contains a row for each partition of all the tables and most types of indexes in the database. Special index types such as Full-Text, Spatial, and XML aren't included in this view. All tables and indexes in SQL Server contain at least one partition, whether or not they are explicitly Indicates the partition ID. Unique within a databa

2016 (13.x) and later versions Returns a row for each table for which periods have been defined. The numeric value representing the type of period: The text description of the type of column: The id of the table containing the period_type column The id of the column that defines the lower period boundary The id of the column that defines the upper period boundary The visibility of the m

Contains a row for each plan guide in the database. Unique identifier of the plan guide in the database.

Contains a row for each object that is a procedure of some kind, with For a list of columns that this view inherits, see 1 = Procedure is auto-executed at the server startup; otherwise, 0. Can only be set for procedures in the master Execution of this procedure is replicated. Replication of the procedure execution is done only when t

2016 (13.x) and later versions SQL database in Microsoft Fabric Contains information about the semantics affecting context settings associated with a query. There are several context settings available in SQL Server that influence the query semantics (defining the correct result of the query). The same query text compiled under different settings might produce different results (dependi

2016 (13.x) and later versions SQL database in Microsoft Fabric Contains information about each execution plan associated with a query.

2022 (16.x) and later versions SQL database in Microsoft Fabric Contains information about Query Store tuning via query feedback features, including cardinality estimation (CE) feedback degree of parallelism (DOP) feedback lock after qualification (LAQ) feedback Uniquely identifies the feedback change applied to a query.

Contains information about Query Store plans that have been forced on secondary replicas , when Query Store for secondary replicas is enabled. You can use this information to determine what queries have plans forced on different replica sets. Query Store for secondary replicas is supported starting in SQL Server 2025 (17.x) and later versions, and in Azure SQL Database.

2016 (13.x) and later versions SQL database in Microsoft Fabric Contains information about the query and its associated overall aggregated runtime execution ID of the database object that the query is part of (stored procedure, trigger, CLR UDF/UDAgg, etc.). if the query isn't executed as part of a database object (ad hoc query). See the ID of the statement batch the query is part of. P

2022 (16.x) and later versions SQL database in Microsoft Fabric Unique identifier of a query hint. Unique identifier of a query in the Query Store. Determines the scope at which the hint is Error code returned when if applying hints Includes the error description of the error Number of times that the query hint application failed since the query hint was created or last Source of Query

2016 (13.x) and later versions SQL database in Microsoft Fabric Contains the Transact-SQL text and the SQL handle of the query. SQL text of the query, as provided by the user. Includes whitespaces, hints, and comments. Comments and spaces before and after the query text are ignored. Comments and spaces inside text aren't ignored. SQL handle of the individual query.

2022 (16.x) and later versions SQL database in Microsoft Fabric Contains information about the parent-child relationships between the original parameterized queries (also known as parent queries), dispatcher plans, and their child query variants. This catalog view offers the ability to view all query variants associated with a dispatcher as well as the original parameterized queries. Qu

Contains information about Query Store replicas, when Query Store for readable secondaries enabled. You can use this information to determine what Query Store to force or unforce a plan on a secondary replica with sys.sp_query_store_set_query_hints Query Store for secondary replicas is supported starting in SQL Server 2025 (17.x) and later versions, and in Azure SQL Database. For complete platform

2016 (13.x) and later versions SQL database in Microsoft Fabric Contains information about the runtime execution statistics information for the query.

2016 (13.x) and later versions SQL database in Microsoft Fabric Contains information about the start and end time of each interval over which runtime execution statistics information for a query has been collected. sys.database_query_store_options (Transact-SQL) sys.query_context_settings (Transact-SQL) sys.query_store_plan (Transact-SQL) sys.query_store_query (Transact-SQL) sys.query_s

To view the integer identifier of any property that exists in a search property list of the current database, use the sys.registered_search_properties catalog view, as follows: PROPERTY_DESCRIPTION =' property_description Specifies a user-defined description of the property. property_description is a string of up to 512 characters. This option is optional.

Drops a property list from the current database if the search property list is currently not associated with any full-text index in the database. property_list_name Is the name of the search property list to be dropped. property_list_name is an identifier.

'Returns a row per remote-login mapping. This catalog view is used to map incoming local logins that claim to be coming from a corresponding server to an actual local login. . This name is supplied by the connection from the "remote" server. Login name that the connection will supply to be mapped. If NULL, the login name that is specified in the connection is used. ID of the server principal to who'

This catalog view contains a row per remote service binding.

Returns the stored resource governor configuration. The object ID of the classifier function in This function is used to classify new sessions and uses rules to route the workload to the appropriate workload group. For more information, see Indicates the current state of resource governor: : SQL Server 2014 (12.x) and later.

Returns the stored resource pool configuration. Each row represents a resource pool. Unique ID of the resource pool. Not nullable.

Returns the stored workload group configuration. Each row represents a workload group. Each workload group uses one resource pool. Unique ID of the workload group. Not nullable.

This catalog views contains one row per route. Service Broker uses routes to locate the network Name of the route, unique within the database. Not NULLABLE. Identifier for the route. Not NULLABLE. Identifier for the database principal that owns the route.

SQL analytics endpoint in Microsoft Fabric Contains a row for each database schema.

Returns a list of securable classes Numerical designation of the class. The visibility of the metadata in catalog views is limited to securables that a user either owns, or on which the user was granted some permission. For more information, see The following example returns the securable classes supported by this instance of SQL Ser

2016 (13.x) and later versions SQL database in Microsoft Fabric Returns a row for each security policy in the database.

2016 (13.x) and later versions SQL database in Microsoft Fabric Returns a row for each security predicate in the database.

Available beginning in SQL Server 2012 (11.x) Service Pack 1, each row in sys.selective_xml_index_paths represents one promoted path for particular selective xml index. If you create a selective xml index on xmlcol of table T using following statement, There will be two new rows in sys.selective_xml_index_paths corresponding to the index sxi1. Unique id of the selective xml index. Promoted path. F

Returns a row for each classified item in the database. Identifies the class of the item on which the classification exists. Will always have the value 1 (representing a column) A description of the class of the item on which the classification exists. will always have the value Represents the ID of the table containing the classified column, corresponding with sys.all_objects.object_id Represents

Contains a row for each sequence object in a database. The starting value for the sequence object. If the sequence object is restarted by using ALTER SEQUENCE it will restart at this value.

Contains one row for each assembly module for the server-level triggers of type TA. This view maps assembly triggers to the underlying CLR implementation. You can join this relation to . The assembly must be loaded into the (object_id) is the key for the relation. This is a FOREIGN KEY reference back to the object upon which this ID of the assembly from which this module was created. The assembly

Contains information about the server audit specification details (actions) in a SQL Server audit on a server instance. For more information, see SQL Server Audit (Database Engine) all audit_action_id's and their names, query sys.dm_audit_actions (Transact-SQL) ID of the audit server specification Name of group or name of audit action Whether the audited object is a group:

Contains information about the server audit specifications in a SQL Server audit on a server instance. For more information on SQL Server Audit, see SQL Server Audit (Database Engine) Name of the server specification. Date the audit server specification was created. Date the audit server specification was last modified. GUID for the audit that contains this specification. Used during enumeration o

Contains one row for each SQL Server audit in a server instance. For more information, see Server Audit (Database Engine) GUID for the audit that is used to enumerate audits with member Server|Database audit specifications during server start-up and UTC date the audit was created. UTC date the audit was last modified.

Returns a row for each server-level event notification object. Server event notification name.

Returns a row for each action on each event of an event session. The ID of the event session. Is not nullable. The ID of the event. This ID is unique within the event session object. Is not nullable.

Returns a row for each event in an event session. The ID of the event session. Is not nullable. The ID of the event. This ID is unique within an event session object. Is The name of the event. Is not nullable.

Returns a row for each customizable column that was explicitly set on events and targets. The ID of the event session. Is not nullable. The ID of the object this field is associated with. Is not nullable.

Returns a row for each event target for an event session. The ID of the event session. Is not nullable. The ID of the target. ID is unique within the event session object. Is not The name of the event target. Is not nullable.

Lists all the server-scoped event session definitions that exist in SQL Server or Azure SQL The unique ID of the event session. Not nullable. The user-defined name for identifying the event session. name Determines how event loss is handled. The default is nullable.

Contains one row for each event for which a server-level event-notification or server-level DDL uniquely identify the server event.

Contains extended information about the file audit type in a SQL Server audit on a server instance. For more information, see SQL Server Audit (Database Engine) UTC date when the file audit was created. UTC date when the file audit was last modified.

Returns one row for each server-level permission. Identifies class of thing on which permission exists. Description of class on which permission exists. One of the ID of the securable on which permission exists, interpreted according to class. For most, this is just the kind of ID that applies to what the class represents. Interpretation for non-standard is as Secondary ID of thing on which permis

Returns the login identification number of the user. Is the login name of the user. is specified as can be any SQL Server login or Windows user or group that has permission to connect to an instance of SQL Server. If is not specified, the login identification number for the current user is returned. If the parameter contains the word NULL

Returns one row for each member of each fixed and user-defined server role. Server-Principal ID of the role. Server-Principal ID of the member. To add or remove server role membership, use the ALTER SERVER ROLE (Transact-SQL) Logins can view their own server role membership and can view the principal_id's of the members of the fixed server roles.

Contains the set of SQL modules for server-level triggers of type TR. You can join this relation to sys.server_triggers. The tuple (object_id) is the key of the relation. This is a FOREIGN KEY reference back to the server-level trigger where this module is defined. SQL text that defines this module. Module was created with ANSI NULLS set option set to ON. Module was created with QUOTED IDENTIFIER

Contains one row for each event for which a server-level (synchronous) trigger fires. Trigger is marked to be the first to fire for this event. Trigger is marked to be the last to fire for this event. The visibility of the metadata in catalog views is limited to securables that a user either owns, or on which the user was granted some permission. For more information, see Object Catalog Views (Tra

Contains the set of all server-level DDL triggers with object_type of TR or TA. In the case of CLR triggers, the assembly must be loaded into the database. All server-level DDL trigger names exist in a single, global scope. Description of class of parent. Is always: Always 0 for triggers on the SERVER. Description of the class of the object type. Date the trigger was last modified by using an ALTE

'Returns a row per linked or remote server registered, and a row for the local server that has value is the local name of linked Product name of the linked server. A value of "SQL Server" indicates another instance of SQL Server. Starting with SQL Server 2019 (15.x), the value "SQLNCLI" maps to the Microsoft OLE DB Driver for SQL OLE DB provider-string connection Is NULL unless the caller has the'

When a route specifies next_hop_address , the network address is determined based on the network address in the name of the service. A route that specifies can specify a service name or broker instance. next_hop_address is the principal server for a database mirror, you must also specify the MIRROR_ADDRESS for the mirror server. Otherwise, this route does not automatically failover to the mirror s

This catalog view contains a row per (contract, message type) pair.

This catalog view contains a row per (service, contract) pair.

This catalog view contains a row for each contract in the database.

This catalog view contains a row per message type registered in the service broker.

This catalog view returns a row for each reference between service and service queue. A service can only be associated with one queue. A queue can be associated with multiple services.

Contains a row for each object in the database that is a service queue, with For a list of columns that this view inherits, see Maximum number of the concurrent readers Three-part name of the activation procedure.

This catalog view contains a row for each service in the database. Case-sensitive name of service, unique within the database. Not Identifier of the service. Not NULLABLE. Identifier for the database principal that owns this service. NULLABLE. Object id for the queue that this service uses. Not NULLABLE.

This feature will be removed in a future version of SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature. Returns one row for each endpoint in the server that carries a SOAP-type payload. For every row in this view, there's a corresponding row with the same catalog view that carries the HTTP configuration metadata.

Represents the information about the tessellation scheme and parameters of each of the ID of the object on which the index is defined. Each (object_id, index_id) pair has a corresponding entry in ID of the spatial index in which the indexed column is defined Name of the tessellation scheme, one of: GEOMETRY_GRID, X-coordinate of the lower-left corner of the bounding box, one of: NULL = Not applica

Represents the main index information of the spatial indexes.

Lists the spatial reference systems (SRIDs) supported by SQL Server. The SRID supported by SQL Server. authorized_spatial_reference_id The SRID given by the authority named in The WKT representation of the SRID.

Contains a row for each dependency on a referenced entity as referenced in the Transact-SQL expression or statements that define some other referencing object. Identifies the class of the referenced entity: 0 = Object or column (non-schema-bound references only) 1 = Object or column (schema-bound references) 2 = Types (schema-bound references) 3 = XML Schema collections (schema-bound references) 4

SQL analytics endpoint in Microsoft Fabric Contains one row for each by-name dependency on a user-defined entity in the current database. This includes dependencies between natively compiled, scalar user-defined functions and other SQL Server modules.

Returns one row for every SQL Server authentication login. Password expiration is checked. Hash of SQL login password. In SQL Server 2022 (16.x) and earlier versions, the stored password information is calculated using SHA-512 of the salted password. Starting with SQL Server 2025 (17.x), an iterated hash algorithm, RFC2898 (PBKDF), is used.

The one-part or two-part name of a schema-scoped securable to be moved into the schema. Users and schemas are completely separate. Schemas aren't equivalent to database users. Use System catalog views to identify any differences between database users and schemas. ALTER SCHEMA can only be used to move securables between schemas in the same database. To change or drop a securable within a schema, u

filtered index, the number of rows might be less than the number of rows in the table. Total number of rows sampled for statistics calculations. Number of steps in the histogram. For more information, see DBCC SHOW_STATISTICS (Transact-SQL) unfiltered_rows Total number of rows in the table before applying the filter expression (for filtered statistics). If statistics are not filtered, unfiltered_r

Contains a row for each column that is part of ID of the object of which this column is part.

Returns one row for every symmetric key created with the CREATE SYMMETRIC KEY statement.

Contains a row for each synonym object that is For a list of columns that this view inherits, see Fully quoted name of the object to which the user of The visibility of the metadata in catalog views is limited to securables that a user either owns, or on which the user was granted some permission. For more information, see Object Cat

Under special circumstances, contains rows corresponding to the files in a database. File identification number. This is unique for each database. File group identification number. File size, in 8-kilobyte (KB) pages. Maximum file size, in 8-KB pages. -1 = File will grow until the disk is full. 268435456 = Log file will grow to a maximum size of 2 TB.

Contains information about how the cache is used. Bucket ID. Value indicates a range from 0 through (directory size - 1). Directory size is the size of the hash table. Ad hoc query (Transact-SQL submitted as language events from the utilities, instead of remote procedure calls) ReplProc (replication procedure) This SQL Server 2000 system table is included as a view for backward compatibility. We r

Contains one row for each character set and sort order defined for use by the SQL Server Database Engine. One of the sort orders is marked in This is the only one actually being used. Type of entity this row represents: Unique ID for the character set or sort order. Note sort orders and character sets cannot share the same ID number.

SQL analytics endpoint in Microsoft Fabric Returns one row for every column in every table and view, and a row for each parameter in a stored procedure in the database.

Contains entries for each view, rule, default, trigger, CHECK constraint, DEFAULT constraint, and stored procedure within the database. The column contains the original SQL definition Object ID to which this text applies. Number within procedure grouping, if grouped. 0 = Entries are not procedures. Row sequence number for object definitions that are longer than 4,000 Identified for informational p

Contains one row for each configuration option set by a user. configuration options that are defined before the most recent startup of SQL Server, plus any dynamic configuration options set since then. User-modifiable value for the variable. This is used by the Database Engine only if RECONFIGURE has been executed. Configuration variable number. Explanation of the configuration option.

Contains an entry for each current configuration option. Also, this view contains four entries that describe the configuration structure. is built dynamically when queried by a user. For more information, see sys.sysconfigures (Transact-SQL) User-modifiable value for the variable. This is used by the SQL Server Database Engine only if RECONFIGURE has been executed. Configuration variable number. E

SQL analytics endpoint in Microsoft Fabric Contains one row for each database in an instance of Microsoft SQL Server. When SQL Server is System ID of the database creator Used internally for locking a database while it is being created. Status bits, some of which can be set by using (ALTER DATABASE using SET RECOVERY) (ALTER DATABASE using SET RECOVERY) This SQL Ser

Contains dependency information between objects (views, procedures, and triggers) in the database, and the objects (tables, views, and procedures) that are contained in their definition. Identified for informational purposes only. Not supported. Future compatibility is not guaranteed. Identifies the dependent object type: 0 = Object or column (non-schema-bound references only 1 = Object or column

Contains one row for each disk backup file, tape backup file, and database file. Logical name of the backup file or database file. Size of the file in 2-kilobyte (KB) pages. Maintained for backward compatibility only. Maintained for backward compatibility only. Bitmap indicating the type of device: This SQL Server 2000 system table is included as a view for backward compatibility.

Contains one row for each file group in a database. There is at least one entry in this table that is for the primary file group. Group identification number unique for each database. Mapping System Tables to System Views (Transact-SQL) Compatibility Views (Transact-SQL) This SQL Server 2000 system table is included as a view for backward compatibility. We recommend that you use the current SQL Se

Contains one row for each file in a database. File identification number unique for each database. File group identification number. Size of the file, in 8-KB pages. Maximum file size, in 8-KB pages. -1 = File will grow until the disk is full. 268435456 = Log file will grow to a maximum size of 2 TB. Note: Databases that are upgraded with an unlimited log file size will report -1 for the maximum s

Contains information about the FOREIGN KEY constraints that are in the definitions of tables in ID of the FOREIGN KEY constraint. Object ID of the table with the FOREIGN KEY constraint. Object ID of the table referenced in the FOREIGN KEY constraint. Position of the column in the reference column list. Mapping System Tables to System Views (Transact-SQL) Compatibility Views (Transact-SQL) This SQL

Contains one row for each index and table in the current database. XML indexes are not supported in this view. Partitioned tables and indexes are not fully supported in this view; use ID of the table to which the index belongs. Identified for informational purposes only. Not supported. Future compatibility is not guaranteed. Pointer to the first or root page. NULL = Index is partitioned when NULL

Contains information about the keys or columns in an index of the database. Position of the column in the index. Mapping System Tables to System Views (Transact-SQL) Compatibility Views (Transact-SQL) sys.index_columns (Transact-SQL) This SQL Server 2000 system table is included as a view for backward compatibility. We recommend that you use the current SQL Server system views instead.

Contains one row for each language present in the instance of SQL Server. for Tuesday, and so on, through Official language name, for example, Alternative language name, for example, Comma-separated list of full-length month names in order from January through December, with each name having up to 20 characters.

Contains information about all granted, converting, and waiting lock requests. Textual description of a lock resource. Contains a part of the Binary lock resource. Contains the actual lock resource that is contained in the lock manager.

Contains one row for each login account. : SQL Server ( SQL Server 2008 (10.0.x) through Identified for informational purposes only. Not supported. Future compatibility is not guaranteed. Identified for informational purposes only. Not supported. Future compatibility is not guaranteed. Identified for informational purposes only. Not supported. Future compatibility is not guaranteed.

Contains a row for each member of a database role. User ID for the role member. Overflows or returns NULL if the number of users and roles exceeds 32,767. User ID for the role. Overflows or returns NULL if the number of users and Mapping System Tables to System Views (Transact-SQL) Compatibility Views (Transact-SQL) This SQL Server 2000 system table is included as a view for backward compatibility

Contains one row for each system error or warning that can be returned by the SQL Server Database Engine. The Database Engine displays the error description on the user's screen. Identified for informational purposes only. Not supported. Future compatibility is not guaranteed. Explanation of the error with placeholders for parameters. Mapping System Tables to System Views (Transact-SQL) Compatibil

SQL analytics endpoint in Microsoft Fabric Contains one row for each object that is created within a database, such as a constraint, default, log, rule, and stored procedure. Object type.

Contains one row for each user and password mapping for the specified linked server. Security identification number (SID) of the server. SID of the local login to be mapped. If 1, the mapping should use the credentials of the user. Date the mapping information was last changed. Compatibility Views (Transact-SQL) This SQL Server 2000 (8.x) system table is included in SQL Server as a view for backwa

Contains a Microsoft SQL Server Database Engine representation of the internal performance counters that can be displayed through the Windows System Monitor. Performance object name, such as Name of the performance counter within the object, such as Named instance of the counter. For example, there are counters maintained for each type of lock, such as instance name distinguishes between similar c

Contains information about permissions granted and denied to users, groups, and roles in the ID of the object for object permissions.

Associates up to 128 bytes of binary information with the current session or connection. constant, or a constant that is implicitly convertible to , to associate with the current session or connection. variable holding a context value to associate with the current session , SET CONTEXT_INFO affects the current session. T

Contains information about permissions that have been applied to security accounts in the database by using the GRANT and DENY statements.

SQL analytics endpoint in Microsoft Fabric Contains mappings of the FOREIGN KEY constraint definitions to the referenced columns within ID of the FOREIGN KEY constraint. Index ID of the unique index on the referenced table covering the Identified for informational purposes only. Not supported. Future compatibility is not guaranteed.

Contains one row for each remote user that is permitted to call remote stored procedures on an instance of Microsoft SQL Server. Login name of the user on a remote server. Microsoft Windows user security ID.

Contains one row for each server that an instance of SQL Server can access as an OLE DB data ID (for local use only) of the remote server. Identified for informational purposes only. Not supported. Future compatibility is not guaranteed. Product name for the remote server. OLE DB provider name for access to this server. Date this row was last updated.

Contains a row for each column of system objects that have columns.

Contains one row for all schema-scoped system objects that are included with Microsoft SQL Server. All system objects are contained in the schemas named sys or INFORMATION_SCHEMA.

Contains one row for each system object that has parameters.

Returns one row per system object that contains a SQL language-defined module. System objects of type FN, IF, P, PC, TF, V have an associated SQL module. To identify the containing object, you can join this view to Object identification number of the containing object, unique SQL text that defines this module. 1 = Module was created

Contains one row for each system view that is shipped with SQL Server. All system views are contained in the schemas named For a list of columns that this view inherits, see 1 = View has a replication filter. 1 = VIEW_METADATA option specified for view. For more 1 = Table contains persisted data that depends on an assembly whose definition changed during the last ALTER ASSEMBLY. Will be reset to 0

Returns one row for each system-supplied and each user-defined data type defined in the Identified for informational purposes only. Not supported. Future compatibility is not guaranteed. Extended user type. Overflows or returns NULL if the number of data types Physical length of the data type.

SQL analytics endpoint in Microsoft Fabric Contains one row for each Microsoft Windows user, Windows group, Microsoft SQL Server user, or SQL Server role in the database. User ID, unique in this database. Overflows or returns NULL if the number of users and roles exceeds Identified for informational purposes only. Not supported. Future compatibility is not guarantee

Displays properties of user-defined table types in SQL Server. A table type is a type from which table variables or table-valued parameters could be declared. Each table type has a that is a foreign key into the catalog view.

SQL analytics endpoint in Microsoft Fabric Warehouse in Microsoft Fabric SQL database in Microsoft Fabric Catalog views return information that is used by the SQL Server Database Engine.

Returns one row for each TCP endpoint in the system. The endpoints that are described by provide an object to grant and revoke the connection privilege. The information that is displayed regarding ports and IP addresses isn't used to configure the protocols and might not match the actual protocol configuration. To view and configure protocols, use SQL Server Configura

2016 (13.x) and later versions SQL analytics endpoint in Microsoft returns information about supported time zones.

Similar event classes are grouped by a category. Each row in the view identifies a category that is unique across the server. These categories do not change for a given version of the SQL Server Database Engine. For a complete list of supported trace events, see SQL Server Event Class Reference Unique ID of this category. This column is also in the Unique name of this category. This parameter is n

Contains one row for each Extended Events action that is mapped to a SQL Trace column ID. This table is stored in the master database, in the sys schema. trace_column_id The ID of the SQL Trace column that is being mapped.

catalog view contains a list of all possible usage combinations of events and columns. For each event listed in the column. Not all available columns are populated each time a given event occurs. These values do not change for a given version of the SQL Server Database For a complete list of supported trace events, see SQL Server Event Class Reference ID of the trace event.

Contains one row for each Extended Events event that is mapped to a SQL Trace event class. This table is stored in the master database, in the sys schema. The ID of the SQL Trace event class that is being mapped.

catalog view contains a list of named column values. These subclass values do not change for a given version of the SQL Server Database Engine. For a complete list of supported trace events, see SQL Server Event Class Reference ID of the trace event. This parameter is also in the ID of the trace column used for enumeration.

catalog view contains the current running traces on the system. This view is intended as a replacement for the For a complete list of supported trace events, see SQL Server Event Class Reference Path of the trace file. This value is null when the trace is a rowset Maximum trace file size limit in megabytes (MB). This value is null when the trace is a rowset trace. Time to stop the running trace. M

Specifies whether poison message handling is enabled for the queue. The default is ON. A queue that has poison message handling set to OFF will not be disabled after five consecutive transaction rollbacks. This allows for a custom poison message handing system to be defined by the application. Specifies the SQL Server filegroup on which to create this queue. You can use the parameter to identify a

Returns a row for each event or event group on which a trigger can fire. Type of event or event group that causes a trigger to fire.

Contains a row per event for which a trigger fires. Trigger is marked to be the first to fire for this event. Trigger is marked to be the last to fire for this event. Event group on which the trigger is created, or null if not created on an event group. Description of the event group on which the trigger is created, or null if not created on an event group.

Contains a row for each object that is a trigger, with a type of TR or TA. DML trigger names are schema-scoped and, therefore, are visible in . DDL trigger names are scoped by the parent entity and are only visible in this view. columns uniquely identify the trigger in the database. Trigger name. DML trigger names are schema-scoped.

Contains a row for each trusted assembly for the server. SHA2_512 hash of the assembly content. Optional user-defined description of the assembly. We recommend using the canonical name that encodes the simple name, version number, culture, public key, and architecture of the assembly to trust.

Contains one row per type to assembly reference. To return the name of the type, join to the role. For more information, see Scalar Types Catalog Views (Transact-SQL)

Contains a row for each system and user-defined type.

Returns one row for every database principal that is part of the user token in SQL Server.

Contains a row per vector index. Type of vector index (DiskANN only for now) Metric used to create the vector index The visibility of the metadata in catalog views is limited to securables that a user either owns, or on which the user was granted some permission.

Contains a row for each view object, with For a list of columns that this view inherits, see 1 = View has a replication filter. 1 = VIEW_METADATA option specified for view. For 1 = View contains persisted data that depends on an assembly whose definition changed during the last ALTER ASSEMBLY. Resets to 0 after the next successful DBCC CHECKDB or DBCC CHECKTABLE. 1

Returns one row per XML index. Nonnull = Secondary XML index. Nonnull is a self-join reference to the primary XML index. Type description of secondary index: R = PROPERTY secondary XML index Type description of secondary index: PATH = PATH secondary XML index VALUE = VALUE secondary XML index PROPERTY = PROPERTY secondary xml indexes.

Returns a row per XML schema component that is an attribute, 1 = The default value is a fixed value. This value cannot be overridden 0 = The default value is not a fixed value for the attribute. (default) 1 = The attribute must be explicitly namespace qualified. 0 = The attribute may be implicitly namespace qualified. (default) Default value of the attribute. Is NULL if a default value is not The

Returns a row per XML schema collection. An XML schema collection is a named set of XSD definitions. The XML schema collection itself is contained in a relational schema, and it is identified by a schema-scoped Transact-SQL name. The following tuples are unique: xml_collection_id, and schema_id and name.

Returns a row per placement for XML schema components.

Returns a row per component of an XML schema. The pair ( compound foreign key to the containing namespace. For named components, the values for Unique ID of the XML schema component in the database.

Returns a row per XML schema component that is a Type, 1 = Default value is a fixed value. This value cannot be overridden 0 = Default value is not a fixed value for the element. (default). 1 = Element is abstract and cannot be used in an instance document. A member of the substitution group of the element must appear in the instance document. 0 = Element is not abstract. (default).

Returns a row per facet (restriction) of an xml-type definition (corresponds to ID of XML component (type) to which this facet belongs. ID (1-based ordinal) of facet, unique within component-id. PT = Pattern (regular expression) WS = White Space normalization

Returns a row per XML schema component that is a Model-Group, Description of compositor kind of group: The visibility of the metadata in catalog views is limited to securables that a user either owns, or on which the user was granted some permission. For more information, see XML Schemas (XML Type System) Catalog Views (Transact-SQL)

Returns a row per XSD-defined XML namespace. The following tuples are unique: ID of the XML schema collection that contains this namespace. 1-based ordinal that uniquely identifies the XML namespace in The visibility of the metadata in catalog views is limited to securables that a user either owns, or on which the user was granted some permission. For more information, see XML Schemas (XML Type Sy

Returns a row per XML schema component that is a Type, 1 = Type is an abstract type. All instances of an element of this type to indicate a derived type that is not abstract. 0 = Type is not abstract. (default) 0 = Mixed content is not allowed. (default) 1 = Replacement with an extension of the type is blocked in instances when the block attribute on the attribute of the ancestor <schema> element

Returns a row per enumerated namespace for an XML schema wildcard.

Returns a row per XML schema component that is an Attribute-Wildcard ( Indicates how contents are processed. S = Strict validation (must validate) L = Lax validation (validate if possible) Description of how contents are processed: sys.xml_schema_wildcard_namespaces 1 = Namespaces are the only ones disallowed.