| title | sys.syscomments (Transact-SQL) | Microsoft Docs | ||||
|---|---|---|---|---|---|
| ms.custom | |||||
| ms.date | 03/15/2017 | ||||
| ms.prod | sql | ||||
| ms.prod_service | database-engine | ||||
| ms.reviewer | |||||
| ms.technology | system-objects | ||||
| ms.topic | language-reference | ||||
| f1_keywords |
|
||||
| dev_langs |
|
||||
| helpviewer_keywords |
|
||||
| ms.assetid | 767dd410-6bc9-4c4a-ab0f-6d2cf6163426 | ||||
| author | rothja | ||||
| ms.author | jroth |
[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx-md]
Contains entries for each view, rule, default, trigger, CHECK constraint, DEFAULT constraint, and stored procedure within the database. The text column contains the original SQL definition statements.
Important
[!INCLUDEssNoteDepFutureDontUse] We recommend that you use sys.sql_modules instead. For more information, see sys.sql_modules (Transact-SQL).
| Column name | Data type | Description |
|---|---|---|
| id | int | Object ID to which this text applies. |
| number | smallint | Number within procedure grouping, if grouped. 0 = Entries are not procedures. |
| colid | smallint | Row sequence number for object definitions that are longer than 4,000 characters. |
| status | smallint | [!INCLUDEssInternalOnly] |
| ctext | varbinary(8000) | The raw bytes of the SQL definition statement. |
| texttype | smallint | 0 = User-supplied comment 1 = System-supplied comment 4 = Encrypted comment |
| language | smallint | [!INCLUDEssInternalOnly] |
| encrypted | bit | Indicates whether the procedure definition is obfuscated. 0 = Not obfuscated 1 = Obfuscated ** Important ** To obfuscate stored procedure definitions, use CREATE PROCEDURE with the ENCRYPTION keyword. |
| compressed | bit | Always returns 0. This indicates that the procedure is compressed. |
| text | nvarchar(4000) | Actual text of the SQL definition statement. The semantics of the decoded expression are equivalent to the original text; however, there are no syntactic guarantees. For example, white spaces are removed from the decoded expression. This [!INCLUDEssVersion2000]-compatible view obtains information from current [!INCLUDEssNoVersion] structures and can return more characters than the nvarchar(4000) definition. sp_help returns nvarchar(4000) as the data type of the text column. When working with syscomments consider using nvarchar(max). For new development work, do not use syscomments. |
Mapping System Tables to System Views (Transact-SQL)
Compatibility Views (Transact-SQL)