Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics Analytics Platform System (PDW) SQL Endpoint in Microsoft Fabric Warehouse in Microsoft Fabric
Contains a row for each object that is a procedure of some kind, with sys.objects.type = P, X, RF, and PC.
|Column name||Data type||Description|
|<Columns inherited from sys.objects>||For a list of columns that this view inherits, see sys.objects (Transact-SQL)|
|is_auto_executed||bit||1 = Procedure is auto-executed at the server startup; otherwise, 0. Can only be set for procedures in the master database.|
|is_execution_replicated||bit||Execution of this procedure is replicated.|
|is_repl_serializable_only||bit||Replication of the procedure execution is done only when the transaction can be serialized.|
|skips_repl_constraints||bit||During execution, the procedure skips constraints marked NOT FOR REPLICATION.|
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. For more information, see Metadata Visibility Configuration.
Object Catalog Views (Transact-SQL)
Catalog Views (Transact-SQL)