Pages

Banner 468 x 60px

 

Tuesday, November 21, 2017

Finding all table Dynamics AX in SQL

0 comments
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

0 comments:

A financial dimension value is based on the record and has been used on a transaction. You cannot delete the record

  SOLUTION delete in table DimensionAttributeLevelValue base on Bank Account  :  and Delete the Bank Account FINISH