Wednesday, March 7, 2012

creating a duplicate table Urgent

Hi All,
I want to create duplicate of a table that is present in database with new name. How can i do it.
I am fogeting the syntax
is it
insert into newtablename from oldtable name
Regards
AdilSELECT * INTO NewTable FROM OldTable|||Remember that your new table will not have any indexes, triggers, constraints, etc that your original table had. It is a duplicate in content only.

blindman|||Originally posted by blindman
will not have any indexes, triggers, constraints, etc
blindman

What are those?|||Ask Sundial. He'll tell you that they aren't really necessary and you can generally ignore them.

blindman :cool:|||And even if you have them in your database, they are self maintaining ... no need to run dbcc's on the database ;)

No comments:

Post a Comment