How to modify the table name in oracle
The editor will share with you how to modify the table name in oracle. I hope you will gain a lot after reading this article. Let's discuss it together.
How to modify the table name by oracle
Mode one
Alter table old_table_name rename to new_table_name
This is the simplest (in my opinion)
Method 2:
Select tname from tab; (querying all table names in the database) rename old_table_name to new_table_name
Rename can only modify the tables under its schema.
Mode 3
Create table new_table_name as select * from old_table_name
It is equivalent to copying into a new table.
Drop table old_table_name; deletes the old table
Mode 4
Change it directly in PLSQL developer.
After reading this article, I believe you have a certain understanding of how to change the table name in oracle, want to know more about it, welcome to follow the industry information channel, thank you for reading!