Menu
Possible Duplicate:
Rename Oracle Table or View
I know you can use
ALTER TABLE oldName RENAME TO newName;
to rename a table, but "ALTER" doesn't work with renaming views.
What's the syntax for renaming Views in Oracle (i'm using 11g if that makes any difference)?
832
Use the RENAME statement to rename a table, view, sequence, or private synonym. Oracle Database automatically transfers integrity constraints, indexes, and grants on the old object to the new object.
To rename a view In Object Explorer, expand the database that contains the view you wish to rename and then expand the View folder. Right-click the view you wish to rename and select Rename. Enter the view's new name.
You can use RENAME on views, like this: Use the RENAME statement to rename a table, view, sequence, or private synonym.
Use the RENAME TABLE statement to rename a view.
You can use RENAME on views, like this:
Use the RENAME statement to rename a table, view, sequence, or private synonym.
RENAME old_view_name to new_view_name
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
