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 distribution database.

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

For internal use only.

xusertype

tinyint

The ID of extended user-defined data type.

length

bigint

The maximum physical storage length from sys.systypes (Transact-SQL).

xprec

int

For internal use only.

xscale

int

For internal use only.

colid

int

The column or parameter ID.

xoffset

int

For internal use only.

bitpos

int

For internal use only.

reserved

int

For internal use only.

colstat

int

For internal use only.

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

For internal use only.

autoval

int

For internal use only.

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

For internal use only.

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

Community Additions

ADD
Show:
© 2014 Microsoft