Example & Tutorial understanding programming in easy ways.

What is RENAME command in SQL?

We use RENAME :

-to change the name of the column.

- to change the name of the table.

How change the name of the column:

Syntax:

ALTER TABLE table_name

RENAME COLUMN old_name to new_name;

How change the name of the table:

Syntax:

ALTER TABLE table_name

RENAME to new_table_name;