how to give an existing table an alternative name on sql code example

ALTER TABLE STUDENTS  
RENAME TO ARTISTS;