find by name and change value sql code example
Example 1: rename table sql
ALTER TABLE STUDENTS
RENAME TO ARTISTS;
Example 2: how to change the column name in sql
ALTER TABLE table_name
CHANGE COLUMN old_name TO new_name;
ALTER TABLE STUDENTS
RENAME TO ARTISTS;
ALTER TABLE table_name
CHANGE COLUMN old_name TO new_name;