var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: creating a duplicate table Urgent
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
insert into newtablename from oldtable name
SELECT * 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.
What are those?
Originally posted by blindman
will not have any indexes, triggers, constraints, etc
Ask Sundial. He'll tell you that they aren't really necessary and you can generally ignore them.
And even if you have them in your database, they are self maintaining ... no need to run dbcc's on the database
Get yourself a copy of the The Holy Book
order has no physical Brett in The meaning of a Kaiser . -database data