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). |
See Also
Reference
Replication Views (Transact-SQL)
sys.columns (Transact-SQL)
Concepts
Replication Tables (Transact-SQL)
Other Resources
Heterogeneous Database Replication