Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to: 
SQL Server
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 | Identified for informational purposes only. Not supported. Future compatibility is not guaranteed. |
| xusertype | tinyint | The ID of extended user-defined data type. |
| length | bigint | The maximum physical storage length from sys.systypes (Transact-SQL). |
| xprec | int | Identified for informational purposes only. Not supported. Future compatibility is not guaranteed. |
| xscale | int | Identified for informational purposes only. Not supported. Future compatibility is not guaranteed. |
| colid | int | The column or parameter ID. |
| xoffset | int | Identified for informational purposes only. Not supported. Future compatibility is not guaranteed. |
| bitpos | int | Identified for informational purposes only. Not supported. Future compatibility is not guaranteed. |
| reserved | int | Identified for informational purposes only. Not supported. Future compatibility is not guaranteed. |
| colstat | int | Identified for informational purposes only. Not supported. Future compatibility is not guaranteed. |
| 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 | Identified for informational purposes only. Not supported. Future compatibility is not guaranteed. |
| autoval | int | Identified for informational purposes only. Not supported. Future compatibility is not guaranteed. |
| 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 | Identified for informational purposes only. Not supported. Future compatibility is not guaranteed. |
| 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). |
See Also
Heterogeneous Database Replication
Replication Tables (Transact-SQL)
Replication Views (Transact-SQL)
sys.columns (Transact-SQL)