|
|
| Re: how to change the exiting filedname to new filedname [message #51975 is a reply to message #51939] |
Mon, 24 June 2002 12:49  |
andrew again
Messages: 2577
Registered: March 2000
|
Senior Member |
|
|
|
I think that is only supported in 9iR2. The usual way is to create a new table with the correct field names; insert your data from the old table into that; drop the old table; rename the new one etc. If you have relationships from that table then it's a pain. You can also just rename the table and create a view using the name you want with the column names you want. As long as that table has a PK then you can insert/update/delete the view as with the table.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
