rename table sql server query code example

Example: rename table sql

ALTER TABLE STUDENTS  
RENAME TO ARTISTS;