sql change table name
snippet in sql

rename table sql

user2827

ALTER TABLE STUDENTS  
RENAME TO ARTISTS;  

sql change table name

user5869

ALTER TABLE exampletable RENAME TO new_table_name;

rename table sql server

user1674

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

modify column name in sql

user7956

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

alter table name sql

user5099

-- Microsoft SQL style
EXEC sp_rename 'TableOldName', 'TableNewName';

change column name sql

user654

ALTER TABLE users
 ALTER COLUMN first username varchar(20);