systranschemas (Transact-SQL)

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

The systranschemas table is used to track schema changes in articles published in transactional and snapshot publications. This table is stored in both publication and subscription databases.

Column name Data type Description
tabid int Identifies the table article on which the schema change occurred.
startlsn binary LSN value at the start of the schema change.
endlsn binary LSN value at the end of the schema change.
typeid int Type of schema change.

See Also

Replication Tables (Transact-SQL)