Dynamics Ax 2012: Number of tables in Dynamics Ax 2012

While working, the question aries in my mind, how many tables and view exists in default dynamics Ax 2012, with out any customization. I queried on Microsoft Dynamics AX database in Sql server

SELECT count(*)NumberOf,table_type FROM information_schema.tables group by table_Type

I found 3198 base tables and 477 Views.

Happy Dynamics Ax development.


Ali Raza Zaidi, Microsoft ERP Consultant, Currently working for Business Experts Gulf in United Arab Emirates. Specialized in HR & Payroll, Supply Chain and Financials modules.