Delete
Do Record
Setting
Add New Item
Menu List
| Title | Content Type | Order | Action | ||||||
|---|---|---|---|---|---|---|---|---|---|
| {{kb_content.name}} {{kb_content.name}} | {{setValue(content_types, kb_content.content_type)}} | {{kb_content.sort_order}} | Preview Edit Edit Content | ||||||
| {{kb_content.name}} | {{setValue(content_types, kb_content.content_type)}} | {{kb_content.sort_order}} | Preview Edit Edit Content | ||||||
| No record | |||||||||
Status: published
Programming, Software and application
2020-12-07 03:13:23
ALTER TABLE RENAME table
1809
Introduction to Oracle Database Oracle Tables and Data definition Modifying data Oracle Query and Filter Oracle data types Joining tables Oracle Operators Grouping data Constraints
এই কোর্সে যা থাকছে
৩টি বিষয়
৮০টি লাইভ ক্লাস
To rename a table, you use the following Oracle RENAME table statement as follows:
RENAME old_table_name TO new_table_name;
In the RENAME table statement:
- First, specify the name of the existing table which you want to rename.
- Second, specify the new table name. The new name must not be the same as another table in the same schema.
Points To Remember:
- you cannot roll back a RENAME statement once you executed it.
- When you rename a table, Oracle automatically transfers indexes, constraints, and grants on the old table to the new one.
- it invalidates all objects that depend on the renamed table such as views, stored procedures, function, and synonyms.
You can also rename table name using following statement
ALTER TABLE old_table_name RENAME TO new_table_name;