| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | f1_keywords | helpviewer_keywords | dev_langs | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
sys.syscomments (Transact-SQL) |
sys.syscomments (Transact-SQL) |
rwestMSFT |
randolphwest |
03/15/2017 |
sql |
system-objects |
reference |
|
|
|
[!INCLUDE SQL Server]
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
[!INCLUDEssNoteDepFutureAvoid] 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)