rename colum in ms sql code example

Example: rename table sql

ALTER TABLE STUDENTS  
RENAME TO ARTISTS;