DynamicsGP
Some useful scripts for Dynamics GP and Navision application.
Wednesday, January 28, 2015
SQL- How to get Extender table script (or other tables started with ***)
SELECT '/* ' + RTRIM(TABLE_NAME) + '*/ SELECT ''' + RTRIM(TABLE_NAME) + ''' AS Extender_Table, * FROM ' + RTRIM(TABLE_NAME) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME LIKE 'EXT%'
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment