sql change table name

1ALTER TABLE STUDENTS  
2RENAME TO ARTISTS;  

1USE AdventureWorks2012;   
2GO  
3EXEC sp_rename 'Sales.SalesTerritory', 'SalesTerr';  
4

1ALTER TABLE "table_name" RENAME COLUMN "column 1" TO "column 2";

1ALTER TABLE table_name
2CHANGE COLUMN old_name TO new_name;
3

1ALTER TABLE exampletable RENAME TO new_table_name;

1ALTER TABLE `Table Name` MODIFY COLUMN `Column Name` Datatype(Size);