TechNet
Export (0) Print
Expand All

IHsyscolumns (Transact-SQL)

 

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 nameData typeDescription
namesysnameThe name of the column or procedure parameter.
idintThe object ID of the table to which this column belongs, or the ID of the stored procedure with which this parameter is associated.
xtypetinyintThe physical storage type from sys.systypes (Transact-SQL).
typestatintIdentified for informational purposes only. Not supported. Future compatibility is not guaranteed.
xusertypetinyintThe ID of extended user-defined data type.
lengthbigintThe maximum physical storage length from sys.systypes (Transact-SQL).
xprecintIdentified for informational purposes only. Not supported. Future compatibility is not guaranteed.
xscaleintIdentified for informational purposes only. Not supported. Future compatibility is not guaranteed.
colidintThe column or parameter ID.
xoffsetintIdentified for informational purposes only. Not supported. Future compatibility is not guaranteed.
bitposintIdentified for informational purposes only. Not supported. Future compatibility is not guaranteed.
reservedintIdentified for informational purposes only. Not supported. Future compatibility is not guaranteed.
colstatintIdentified for informational purposes only. Not supported. Future compatibility is not guaranteed.
cdefaultintThe ID of the default for this column.
domainintThe ID of the rule or CHECK constraint for this column.
numberintThe Subprocedure number when the procedure is grouped (0 for nonprocedure entries).
colorderintIdentified for informational purposes only. Not supported. Future compatibility is not guaranteed.
autovalintIdentified for informational purposes only. Not supported. Future compatibility is not guaranteed.
offsetintThe offset into the row in which this column appears.
collationidintThe ID of the collation of the column. NULL for non-character based columns.
languageintThe language identifier for the column.
statusintThe 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.
typeintThe physical storage type from sys.systypes (Transact-SQL).
usertypetinyintThe ID of user-defined data type from sys.systypes (Transact-SQL).
printfmtintIdentified for informational purposes only. Not supported. Future compatibility is not guaranteed.
precintThe level of precision for this column.
scaleintThe scale for this column.
iscomputedintThe flag indicating whether the column is computed:

 0 = Noncomputed.

 1 = Computed.
isoutparamintIndicates whether the procedure parameter is an output parameter:

 1 = True.

 0 = False.
isnullableintIndicates whether the column allows null values:

 1 = True.

 0 = False.
collationintThe name of the collation of the column. NULL for non-character based columns.
tdscollationintThe 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)

Community Additions

ADD
Show:
© 2016 Microsoft