Hi,
Can anybody help me? I want to create a new table and i want to import the structure of another table to that new table but not the data.I want to do it by executing a single sql statement.Would it be possible?
Thanks!!
JoydeepSELECT * INTO NewTable FROM OldTable WHERE 0=1
It will not bring over contraints or indexes.
To do that you need to script the table and copy them so they can be applied.
Don't know how to script? Look at the first sticky post in this forum and look for the FAQ section|||thanks a lot. :)
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment