How To Change Table Name In SQL?

Use `ALTER TABLE old_table_name RENAME TO new_table_name;`

Use `RENAME TABLE old_table_name TO new_table_name;`

Use `sp_rename ‘old_table_name’, ‘new_table_name’;`

Use `EXEC sp_rename ‘schema.old_table_name’, ‘new_table_name’;`

Use `ALTER TABLE old_table_name RENAME new_table_name;`

Use `ALTER TABLE old_table_name RENAME TO new_table_name CASCADE;`

Use `ALTER TABLE old_table_name RENAME TO new_table_name RESTRICT;`