select *
from INFORMATION_SCHEMA.TABLES
where TABLE_NAME like '%parameters%' and
TABLE_NAME not like '%_BE' and
TABLE_NAME not like '%_BR' and
TABLE_NAME not like '%_CN' and
TABLE_NAME not like '%_DE' and
TABLE_NAME not like '%_NL' and
TABLE_NAME not like '%_RU' and
TABLE_NAME not like '%_UK';
My technical memo on Microsoft Dynamics 365 for Finance and Operations (formerly AX)
Friday, March 18, 2016
SQL Server: Display table name
Hi, today I will show the simple query which run on Query editior on MS SQL Server Management studio. It displays the table names in Dynamics AX database.
Labels:
tech_SQL Server
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment