Duplicate table structure

The table structure of a is copied to the A1 table, 1=2 does not copy the data, if you want to copy the data, do not where
SELECT * into A1 from a where 1=2

Note: You cannot copy information such as primary key, index, etc. in this way
If you want to copy all, you can just right-click on the A table and select "Write table script as" = "Create
Then change a to A1 on the basis of this structure (note: To choose to write an index script in the settings)

Ask

Great God, this is possible, there is no way to copy the tables in the database.

Reply

Then write a stored procedure, from the result of executing this SQL sequentially
Select ' SELECT * into ' + name + ' 1 from ' + name from Sys.tables t

Duplicate table structure