Question

Manika wants to rename a table in her database using SQL commands. Which category of  commands should she use? i. DDL ii. DCL iii. DML iv. TCL​

Answer 1

She should use the (i) DDL category of commands.

The command for renaming a table is:

Alter table <table_name> rename to <new_table_name>;

DDL [data definition language] commands are those commands that are involved in making changes to the structure of the table. They include commands such as Alter, Drop, Create, Truncate, etc.

• Alter - used for making changes to the definition of the table
• Drop - used to delete a table/database
• Create - used to create a table
• Truncate - used to delete data from a table