sys.dm_repl_schemas (Transact-SQL)

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)