sql change table name tsql code example

Example: rename table sql

ALTER TABLE STUDENTS  
RENAME TO ARTISTS;