systranschemas (Transact-SQL)

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

Reference

Replication Views (Transact-SQL)

Concepts

Replication Tables (Transact-SQL)

Help and Information

Getting SQL Server 2005 Assistance