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 |
|
shylender
Starting Member
4 Posts |
 Posted - 2007-08-07 : 23:40:57
|
| Query for creating Duplicate table(Structure,Data and Constraints). I write like this Select * into table2 from table1. But only structure and data is creating. Please help me... |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-07 : 23:51:24
|
| You can script constraints and so, modify the script then create them in new table with the script. |
 |
|
|
shylender
Starting Member
4 Posts |
Posted - 2007-08-08 : 00:07:03
|
quote:
Originally posted by rmiao
You can script constraints and so, modify the script then create them in new table with the script.
Thanks for your reply...Actually duplicate tables should be created in code. Is there any method to write query.. Please help me |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2007-08-08 : 01:38:32
|
| Why do you want to create duplicate tables dynamically?MadhivananFailing to plan is Planning to fail |
|
|
|
shylender
Starting Member
4 Posts |
Posted - 2007-08-08 : 02:07:01
|
quote:
Originally posted by madhivanan
Why do you want to create duplicate tables dynamically?MadhivananFailing to plan is Planning to fail
we are using Joomla CMS(PHP) and backend as SQL Server. For that we have component for creating Multisites. So it is creating duplicates tables for every new site. Please help me is there any procedure for that... |
|
|
|
|
|
|
Creating Duplicate Tables