Nuta
Dostęp do tej strony wymaga autoryzacji. Możesz spróbować się zalogować lub zmienić katalog.
Dostęp do tej strony wymaga autoryzacji. Możesz spróbować zmienić katalogi.
The IHcolumns system table contains one row for each published column. This table is used to define how column data types from the non-SQL Server Publisher will be represented when published, which essentially maps data types between a non-SQL Server database management systems (DBMS) and SQL Server. This table is stored in the distribution database.
Definition
Column name |
Data type |
Description |
|---|---|---|
column_id |
int |
Identifies a published column. |
publishercolumn_id |
int |
Associates a published column with column metadata stored in the IHpublishercolumns system table. |
name |
sysname |
Specifies the column name. |
article_id |
int |
Identifies the article to which the column belongs. |
column_ordinal |
int |
Identifies the column by order. |
mapped_type |
tinyint |
The column data type of the destination column at Subscriber. |
mapped_length |
bigint |
The length of the column at Subscriber. |
mapped_prec |
int |
The precision of the column at Subscriber. |
mapped_scale |
int |
The scale of the column at Subscriber. |
mapped_nullable |
bit |
Indicates whether the column at the Subscriber accepts NULL values, where 1 means that NULL values are accepted. |
Zobacz także
Odwołanie
Replication Views (Transact-SQL)
sp_articlecolumn (Transact-SQL)
sysarticlecolumns (Transact-SQL)
Koncepcje
Heterogeneous Database Replication