sql rename a table code example
Example 1: rename table sql
ALTER TABLE STUDENTS
RENAME TO ARTISTS;
Example 2: rename table sql server
USE AdventureWorks2012;
GO
EXEC sp_rename 'Sales.SalesTerritory', 'SalesTerr';
ALTER TABLE STUDENTS
RENAME TO ARTISTS;
USE AdventureWorks2012;
GO
EXEC sp_rename 'Sales.SalesTerritory', 'SalesTerr';