top of page
Search

SQL - List of tables which enable change tracking

  • ABS
  • Oct 23, 2021
  • 1 min read

select sys.schemas.name as Schema_name, sys.tables.name as Table_name 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

 
 
 

Recent Posts

See All
SAP B1/iVend- Query Inventory In SAP

Check inventory audit in SAP select  a.CreateDate, b.USER_CODE as [User], a.TransType SAP_DocType, case when a.TransType = 13 then  'Sale...

 
 
 

Comments


Post: Blog2_Post

©2021 by Addon Business Solution Co., Ltd.

bottom of page