rename table sql server
snippet in sql

rename table sql

user1135

ALTER TABLE STUDENTS  
RENAME TO ARTISTS;  

rename table sql server

user6794

USE AdventureWorks2012;   
GO  
EXEC sp_rename 'Sales.SalesTerritory', 'SalesTerr';