mssql rename a table code example

Example: rename table sql

ALTER TABLE STUDENTS  
RENAME TO ARTISTS;