| title | IHsyscolumns (Transact-SQL) | Microsoft Docs | ||
|---|---|---|---|
| ms.custom | |||
| ms.date | 03/06/2017 | ||
| ms.prod | sql-server-2016 | ||
| ms.reviewer | |||
| ms.suite | |||
| ms.technology |
|
||
| ms.tgt_pltfrm | |||
| ms.topic | language-reference | ||
| applies_to |
|
||
| f1_keywords |
|
||
| dev_langs |
|
||
| helpviewer_keywords |
|
||
| ms.assetid | 263452f1-9708-48f0-9536-402a89e7f5bf | ||
| caps.latest.revision | 12 | ||
| author | BYHAM | ||
| ms.author | rickbyh | ||
| manager | jhubbard |
[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx_md]
The IHsyscolumns view exposes column information for articles published from a non-SQL Server Publisher. This view is stored in the distributiondatabase.
| Column name | Data type | Description |
|---|---|---|
| name | sysname | The name of the column or procedure parameter. |
| id | int | The object ID of the table to which this column belongs, or the ID of the stored procedure with which this parameter is associated. |
| xtype | tinyint | The physical storage type from sys.systypes (Transact-SQL). |
| typestat | int | [!INCLUDEssInternalOnly] |
| xusertype | tinyint | The ID of extended user-defined data type. |
| length | bigint | The maximum physical storage length from sys.systypes (Transact-SQL). |
| xprec | int | [!INCLUDEssInternalOnly] |
| xscale | int | [!INCLUDEssInternalOnly] |
| colid | int | The column or parameter ID. |
| xoffset | int | [!INCLUDEssInternalOnly] |
| bitpos | int | [!INCLUDEssInternalOnly] |
| reserved | int | [!INCLUDEssInternalOnly] |
| colstat | int | [!INCLUDEssInternalOnly] |
| cdefault | int | The ID of the default for this column. |
| domain | int | The ID of the rule or CHECK constraint for this column. |
| number | int | The Subprocedure number when the procedure is grouped (0 for nonprocedure entries). |
| colorder | int | [!INCLUDEssInternalOnly] |
| autoval | int | [!INCLUDEssInternalOnly] |
| offset | int | The offset into the row in which this column appears. |
| collationid | int | The ID of the collation of the column. NULL for non-character based columns. |
| language | int | The language identifier for the column. |
| status | int | The bitmap used to describe a property of the column or the parameter: 0x08 = Column allows null values. 0x10 = ANSI padding was in effect when varchar or varbinary columns were added. Trailing blanks are preserved for varchar and trailing zeros are preserved for varbinary columns. 0x40 = Parameter is an OUTPUT parameter. 0x80 = Column is an identity column. |
| type | int | The physical storage type from sys.systypes (Transact-SQL). |
| usertype | tinyint | The ID of user-defined data type from sys.systypes (Transact-SQL). |
| printfmt | int | [!INCLUDEssInternalOnly] |
| prec | int | The level of precision for this column. |
| scale | int | The scale for this column. |
| iscomputed | int | The flag indicating whether the column is computed: 0 = Noncomputed. 1 = Computed. |
| isoutparam | int | Indicates whether the procedure parameter is an output parameter: 1 = True. 0 = False. |
| isnullable | int | Indicates whether the column allows null values: 1 = True. 0 = False. |
| collation | int | The name of the collation of the column. NULL for non-character based columns. |
| tdscollation | int | The name of the collation of the column when returned in a tabular data stream (TDS). |
Heterogeneous Database Replication
Replication Tables (Transact-SQL)
Replication Views (Transact-SQL)
sys.columns (Transact-SQL)