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;
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