create tables
I have to create 200 tables with the exact same structure. The easiest way is to copy-paste the code and apply different names for the tables. I want to be cool and create them with one cycle. How can I make that cycle and what is best way to apply the different names ? (Using sql server)Thanks
Joginder BangerPosted Nov 21, 2014, 4:24 AM
if you want some table name changed try
this query
select case when Name='yourtablename' then'tableNamechange' else name end from sys.tables where type='U'