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