title: "sys.procedures (Transact-SQL) | Microsoft Docs" ms.custom: "" ms.date: "03/15/2017" ms.prod: sql ms.prod_service: "database-engine, sql-database, sql-data-warehouse, pdw" ms.component: "system-catalog-views" ms.reviewer: "" ms.suite: "sql" ms.technology: system-objects ms.tgt_pltfrm: "" ms.topic: "language-reference" f1_keywords:
- "procedures"
- "sys.procedures_TSQL"
- "sys.procedures"
- "procedures_TSQL" dev_langs:
- "TSQL" helpviewer_keywords:
- "sys.procedures catalog view" ms.assetid: d17af274-b2dd-464e-9523-ee1f43e1455b caps.latest.revision: 20 author: edmacauley ms.author: edmaca manager: craigg monikerRange: ">=aps-pdw-2016||=azuresqldb-current||=azure-sqldw-latest||>=sql-server-2016||=sqlallproducts-allversions||>=sql-server-linux-2017"
[!INCLUDEtsql-appliesto-ss2008-all-md]
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. |
[!INCLUDEssCatViewPerm] For more information, see Metadata Visibility Configuration.
Object Catalog Views (Transact-SQL)
Catalog Views (Transact-SQL)