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 |
|
Eagle_f90
Constraint Violating Yak Guru
424 Posts |
 Posted - 2002-11-16 : 22:16:31
|
| Hi, I was hoping you guys could help me with this. I have an existing table which I want to make copies of. What I want to do is when the copy is made it creates a new table with a different name but all the same info. I did a search and found a way to do it with stored procedures but I don't want to use a stored procedure to do this. Thanks for the help.--For thouse with wings, fly to your dreams. |
|
|
rharmon
Starting Member
41 Posts |
Posted - 2002-11-16 : 22:30:19
|
| select * into someothertablefrom sometable |
 |
|
|
ValterBorges
Master Smack Fu Yak Hacker
1429 Posts |
Posted - 2002-11-17 : 02:00:17
|
| How would you like to do it? |
|
|
|
Eagle_f90
Constraint Violating Yak Guru
424 Posts |
Posted - 2002-11-17 : 02:18:04
|
| @rharmon Thanks that does the trick@ValterBorges I just wanted a small script to run in the quarry analyzer to make the tables. I just had one that need to be copied for 12 different tables with different names.--For thouse with wings, fly to your dreams. |
|
|
|
|
|
|
Copying tables