I presume I can just union tables?  I extract them by the query below so them I am sure all are included.

SELECT *

FROM INFORMATION_SCHEMA.TABLES

WHERE (TABLE_NAME LIKE 'abcd%' )

order by TABLE_NAME

Thank...

Hi,

I also need to Create View Script for all tables for report purposes. Tables get updated daily. I can't afford any crashing.

I am a novice in SQL,  I would appreciate...