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 ;)
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment