Sledeći upit izlistava sve tabele u bazi koje imaju uključen Change Tracking:
USE ime_baze
go
SELECT sys.schemas.name AS SchemaName, sys.tables.name AS TableName FROM sys.change_tracking_tables
JOIN sys.tables ON sys.tables.object_id = sys.change_tracking_tables.object_id
JOIN sys.schemas ON sys.schemas.schema_id = sys.tables.schema_id
USE ime_baze
go
SELECT sys.schemas.name AS SchemaName, sys.tables.name AS TableName FROM sys.change_tracking_tables
JOIN sys.tables ON sys.tables.object_id = sys.change_tracking_tables.object_id
JOIN sys.schemas ON sys.schemas.schema_id = sys.tables.schema_id
Нема коментара:
Постави коментар