Rename table name

Basic syntax for renaming table name

ALTER TABLE table_name RENAME TO new_table_name;

example :
ALTER TABLE suppliers RENAME TO customers;

this script will change table name from "table_name" to "new_table_name"