ALTER TABLE old_table_name RENAME TO new_table_name;
ALTER TABLE STUDENTS RENAME TO ARTISTS;
USE AdventureWorks2012; GO EXEC sp_rename 'Sales.SalesTerritory', 'SalesTerr';
EXEC SP_RENAME 'TABLE_NAME.OLD_COLUMN_NAME','NEW_COLUMN_NAME'
ALTER TABLE nom_table RENAME COLUMN colonne_ancien_nom TO colonne_nouveau_nom