Edit

sys.dm_repl_schemas (Transact-SQL)

  • Article

Applies to: SQL Server

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.

Permissions

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

Permissions for SQL Server 2022 and later

Requires VIEW DATABASE PERFORMANCE STATE permission on the database.

Remarks

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

See also

Dynamic Management Views and Functions (Transact-SQL)
Replication Related Dynamic Management Views (Transact-SQL)