IHsyscolumns (Transact-SQL)

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

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)