rename table name query in sql server code example
Example 1: rename table sql
ALTER TABLE STUDENTS
RENAME TO ARTISTS;
Example 2: how to rename columns in sql server
EXEC sp_rename 'Sales.SalesTerritory.TerritoryID', 'TerrID', 'COLUMN';
ALTER TABLE STUDENTS
RENAME TO ARTISTS;
EXEC sp_rename 'Sales.SalesTerritory.TerritoryID', 'TerrID', 'COLUMN';