Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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