mssql change table name by select code example

Example: rename table sql

ALTER TABLE STUDENTS  
RENAME TO ARTISTS;