sys.procedures (Transact-SQL)
Applies to: 
SQL Server
Azure SQL Database
Azure SQL Managed Instance
Azure Synapse Analytics
Analytics Platform System (PDW)
SQL analytics 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. |
Permissions
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 Metadata Visibility Configuration.
See Also
Object Catalog Views (Transact-SQL)
Catalog Views (Transact-SQL)