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.
| Author |
Topic |
|
Richard Thomas
Starting Member
4 Posts |
 Posted - 2008-07-11 : 09:52:22
|
| I am currently using toad and want to test a table I can't test original table as it will cause many problems to our system so want to copy the table and rename but keep all constraints, indexes and partitions. would appreciate any help, I have tried copying the original tables creation script and amending the table name but doesn't work i think because all consraints are still enforced? |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-11 : 22:26:43
|
| You need copy all related tables together. |
 |
|
|
Richard Thomas
Starting Member
4 Posts |
Posted - 2008-07-14 : 04:59:23
|
| Anyone else able to help me would be really appreciated |
|
|
|
Richard Thomas
Starting Member
4 Posts |
Posted - 2008-07-15 : 11:37:13
|
| i HAVE MANAGED TO FIX THE PROBLEM AND HAVE HAD TO PERFORM A LONG WINDED CREATION WHEREBY CREATE EACH SEPERATE PART OF THE TABLE START WITH PARTITIONS THEN INDEXES AND FINANLLY THE CONSTRAINTS. THAT WAS REALLY LONG BUT IT IS READY FOR USE. |
|
|
|
Richard Thomas
Starting Member
4 Posts |
Posted - 2008-07-15 : 11:37:14
|
| i HAVE MANAGED TO FIX THE PROBLEM AND HAVE HAD TO PERFORM A LONG WINDED CREATION WHEREBY CREATE EACH SEPERATE PART OF THE TABLE START WITH PARTITIONS THEN INDEXES AND FINANLLY THE CONSTRAINTS. THAT WAS REALLY LONG BUT IT IS READY FOR USE. |
|
|
|
|
|
|
Copying a Table with partitions consteraints index