Export (0) Print
Expand All

IHsyscolumns (Transact-SQL)

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).

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft