how to give ame to a ew subtable i SQL code example

Example 1: sql change table name

ALTER TABLE exampletable RENAME TO new_table_name;

Example 2: alter table name sql

-- Microsoft SQL style
EXEC sp_rename 'TableOldName', 'TableNewName';