Microsoft Dynamics AX,
Getting list of Non AOT tables,
select table_name
from information_schema.tables st
where st.table_name not in (select SQLNAME
from SQLDICTIONARY sd
where sd.FIELDID = 0
and sd.ARRAY=0
AND sd.FLAGS = 0)
and st.table_name <> 'SQLSYSTEMVARIABLES';
Thursday, October 28, 2010
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment