rename table sql
ALTER TABLE STUDENTS RENAME TO ARTISTS;
Rename temp table column name in sql server
EXEC tempdb.sys.sp_rename N'##BigTable.Nos', N'Numbers', N'COLUMN';
Source: stackoverflow.com
how to rename column name in sql server using query
EXEC sp_RENAME 'TableName.OldColumnName' , 'NewColumnName', 'COLUMN'
Source: stackoverflow.com