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 |
|
gupta
Starting Member
25 Posts |
 Posted - 2011-02-16 : 15:43:26
|
| Hi Guys,here is small question for you, since I am trying to copy multiple tables in same database not able to do this.Can I know the command to copy multiple tables in same database.(Note: copying multiple tables at a time in same database).Can anybody help me out in this issue.Thanks,M.Harinath Gupta. |
|
|
pk_bohra
Master Smack Fu Yak Hacker
1182 Posts |
Posted - 2011-02-16 : 23:34:59
|
| AFAIK, there is no such command that can be use to copy multiple tables in single shot.You can try "Task-> Export data" wizard to copy multiple tables but remember that PK & FK constraint will not be automatically created in new tables. |
 |
|
|
|
|
|
SQL SERVER-2008 (Copying Of Tables)