SQL: 04 - ALTER TABLE

ALTER TABLE

Syntax

 

Example

ALTER TABLE table_name AUTO_INCREMENT=1000

 

ADD

Syntax

ALTER TABLE table_name

ADD col_name varchar(255)

 

Example

 

MODIFY

Syntax

ALTER TABLE table_name

MODIFY col_name varchar(30)

 

Example

ALTER TABLE medialist

MODIFY COLUMN MediaBrand varchar(35)

 

DROP

Syntax

ALTER TABLE table_name

DROP COLUMN col_name

 

Example