-
I have 2 to 3 columns in one table that really should be in another table. Is there a way to move columns and data over to another table. I was thinking something like creating the a new table with all the columns I want and then doing an insert based on a select. This will be eventually changed on a production database so I need to keep the names of the tables the same. Thanks for any suggestions.
-
You cannot move a column from one table to another table.
-
Any suggested work around?
-
You can create a table with select including all the columns u need. Then drop the original table. Rename the new table u have created to the old table.
-
OK - thats what I thought just wanted to confirm. Thanks.
-
Once you copy the data from the original table, you may just want to drop the columns (oracle 8i onwards).
(this way you r not dropping the original table)
Now you can rename the tables, if you need to.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|