Question

how can we rename table and delete a table.? ​

Answer 1

Answer:

TO RENAME A TABLE:

• Syntax(Oracle,MySQL,MariaDB): ALTER TABLE table_name RENAME TO new_table_name;
• Columns can be also be given new name with the use of ALTER TABLE. Syntax(Oracle): ALTER TABLE table_name RENAME COLUMN old_name TO new_name;
• Syntax(MySQL,MariaDB): ALTER TABLE table_name CHANGE COLUMN old_name TO new_name;

TO DELETE A TABLE:

• In Object Explorer, select the table you want to delete.
• Right-click the table and choose Delete from the shortcut menu.
• A message box prompts you to confirm the deletion. Click Yes. Deleting a table automatically removes any relationships to it.