dynamically create table statement in sql

Question

how to dynamically create a table with same columns as that of previous table. in sql

Carlos Gutiérrez · Accepted Answer · 2010-01-25 07:33:57Z

5

select * into new_table from table where 1 = 0

answered Jan 25, 2010 at 7:33

Carlos Gutiérrez

14.3k5 gold badges39 silver badges47 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

adopilot · Accepted Answer · 2010-01-25 07:11:52Z

2

select * into new_table from table

Thats works in SQL2005

answered Jan 25, 2010 at 7:11

adopilot

4,58015 gold badges69 silver badges96 bronze badges

1 Comment

Innova Over a year ago

thanks for your reply, i need to create oly the table with the entire columns and not the datas. the fresh datas has to be into the new table.

DataGirl · Accepted Answer · 2011-05-03 20:57:58Z

0

I believe that both of the above answers will work, but since you don't need the data and you just need the format, I would do the following:

select * into new_table from table

TRUNCATE new_table; -- I'm sure you know this, but just in case someone is new and doesn't, truncate leaves the table structure and removes all of the data.

answered May 3, 2011 at 20:57

DataGirl

4499 silver badges21 bronze badges

Collectives™ on Stack Overflow

dynamically create table statement in sql

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related