Export (0) Print
Expand All

sys.dm_repl_schemas (Transact-SQL)

Returns information about table columns published by replication.

Column name

Data type

Description

artcache_schema_address

varbinary(8)

In-memory address of the cached schema structure for the published table article.

tabid

bigint

ID of the replicated table.

indexid

smallint

ID of a clustered index on the published table.

idSch

bigint

ID of the table schema.

tabschema

nvarchar(510)

Name of the table schema.

ccTabschema

smallint

Character length of the table schema.

tabname

nvarchar(510)

Name of the published table.

ccTabname

smallint

Character length of the published table name.

rowsetid_delete

bigint

ID of the deleted row.

rowsetid_insert

bigint

ID of the inserted row.

num_pk_cols

int

Number of primary key columns.

pcitee

binary(8000)

Pointer to the query expression structure used to evaluate computed column.

re_numtextcols

int

Number of binary large object columns in the replicated table.

re_schema_lsn_begin

binary(8000)

Beginning log sequence number (LSN) of schema version logging.

re_schema_lsn_end

binary(8000)

Ending LSN of schema version logging.

re_numcols

int

Number of columns published.

re_colid

int

Column identifier at the Publisher.

re_awcName

nvarchar(510)

Name of the published column.

re_ccName

smallint

Number of characters in the column name.

re_pk

tinyint

Whether the published column is part of a primary key.

re_unique

tinyint

Whether the published column is part of a unique index.

re_maxlen

smallint

Maximum length of the published column.

re_prec

tinyint

Precision of the published column.

re_scale

tinyint

Scale of the published column.

re_collatid

bigint

Collation ID for published column.

re_xvtype

smallint

Type of the published column.

re_offset

smallint

Offset of the published column.

re_bitpos

tinyint

Bit position of the published column, in the byte vector.

re_fNullable

tinyint

Specifies whether the published column supports NULL values.

re_fAnsiTrim

tinyint

Specifies whether ANSI trim is used on the published column.

re_computed

smallint

Specifies whether the published column is a computed column.

se_rowsetid

bigint

ID of the rowset.

se_schema_lsn_begin

binary(8000)

Beginning LSN of schema version logging.

se_schema_lsn_end

binary(8000)

Ending LSN of schema version logging.

se_numcols

int

Number of columns.

se_colid

int

ID of the column at the Subscriber.

se_maxlen

smallint

Maximum length of the column.

se_prec

tinyint

Precision of the column.

se_scale

tinyint

Scale of the column.

se_collatid

bigint

Collation ID for column.

se_xvtype

smallint

Type of the column.

se_offset

smallint

Offset of the column.

se_bitpos

tinyint

Bit position of the column, in the byte vector.

se_fNullable

tinyint

Specifies whether the column supports NULL values.

se_fAnsiTrim

tinyint

Specifies whether ANSI trim is used on the column.

se_computed

smallint

Specifies whether the columnis a computed column.

se_nullBitInLeafRows

int

Specifies whether the column value is NULL.

Requires VIEW DATABASE STATE permission on the publication database to call dm_repl_schemas.

Information is only returned for replicated database objects that are currently loaded in the replication article cache.

Community Additions

ADD
Show:
© 2014 Microsoft