rename a table column name in sql code example
Example 1: rename table sql
ALTER TABLE STUDENTS
RENAME TO ARTISTS;
Example 2: alter table name sql
-- Microsoft SQL style
EXEC sp_rename 'TableOldName', 'TableNewName';
ALTER TABLE STUDENTS
RENAME TO ARTISTS;
-- Microsoft SQL style
EXEC sp_rename 'TableOldName', 'TableNewName';