Finding all table Dynamics AX in SQL :
select * from INFORMATION_SCHEMA.COLUMNS where COLUMN_NAME like 'IsTransferred%'
select TABLE_NAME, COLUMN_NAME from INFORMATION_SCHEMA.COLUMNS order by TABLE_NAME
select * from INFORMATION_SCHEMA.COLUMNS where COLUMN_NAME like 'IsTransferred%'
select TABLE_NAME, COLUMN_NAME from INFORMATION_SCHEMA.COLUMNS order by TABLE_NAME
0 comments:
Post a Comment