Payne's SQL Note #7

Back to Payne's SQL Notebook


Add, Delete, and Modify a Column in a Table

Add a Column

Syntax
ALTER TABLE table_name
ADD column_name data_type

Delete a Column

Syntax
ALTER TABLE table_name
DROP COLUMN column_name

Chang Data Type of a Column

Syntax
ALTER TABLE table_name
MODIFY COLUMN column_name data_type