Events
31 Mar, 23 - 2 Apr, 23
The biggest SQL, Fabric and Power BI learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todaysystranschemas (Transact-SQL)
Applies to: 
SQL Server
The systranschemas table is used to track schema changes in articles published in transactional and snapshot publications and for Change Data Capture. 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. |