01-30-2015 08:49 AM
Well, I could be wrong here as haven't pushed the boundaries, but from memory you can put many sql create table statements (just tested creating 500 tables no probs), into one SQL step. Couldn't get a limit there. However I have run into difficulties when combining - e.g. merging/using as lookup, lots of tables - i.e. > 20 in one sql step. (So select * from A left join B left join C etc.). So yes, just test it (and if you hit a boundary ask yourself are you coding it in the best way).