Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Select Into With Constraint

Author  Topic 

GhantaBro
Posting Yak Master

215 Posts

Posted - 2008-07-31 : 15:03:12
How can I make a copy of a table without losing the original constraints in that table guys? Thanks!

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-07-31 : 15:25:29
Script the table with Generate script task.
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-07-31 : 23:44:35
Copy with ssis' copy db object task.
Go to Top of Page
   

- Advertisement -