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 column is 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)