Renaming a Table

Description

If you have a table with an undesired name, you can change this details.

To specify the new name of the table, click New Table Name, type the desired name, click Next and follow the wizard. 

To rename a table in PL/SQL, you can use the following formula:
ALTER TABLE ExistingTableName RENAME TO NewTableName
Here is an example:

ALTER TABLE Contrators RENAME TO Employees;
 
 

No comments:

Post a Comment

Related Scripting

Related Posts Plugin for WordPress, Blogger...

Disqus for Functions