Wednesday 5 December 2012

How to rename table in Oracle database?

Method 1: Simple
rename {old_table_name} to {new_table_name}

Example:
rename CUSTOMER to CUSTOMER_BACKUP

Method 2:

alter table {old_table_name} rename to {new_table_name};

Example:
alter table CUSTOMER rename to CUSTOMER_BACKUP;

No comments:

Post a Comment