หมายเหตุ
การเข้าถึงหน้านี้ต้องได้รับการอนุญาต คุณสามารถลอง ลงชื่อเข้าใช้หรือเปลี่ยนไดเรกทอรีได้
การเข้าถึงหน้านี้ต้องได้รับการอนุญาต คุณสามารถลองเปลี่ยนไดเรกทอรีได้
Applies to: 
SQL Server
Azure SQL Database
Azure SQL Managed Instance
Azure Synapse Analytics
SQL analytics endpoint in Microsoft Fabric
Warehouse in Microsoft Fabric
SQL database 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.