SQL Alter Table Statement is used to add , drop or modify column in exiting table .
SQL Alter Table Statement syntax
To Add a column to exiting table ,use the following syntax
ALTER TABLE table_name ADD column_name datatype
To Delete or drop a column in a table , use following statement
ALTER TABLE table_name DROP COLUMN column_name
SQL Alter Table Statement syntax
To Add a column to exiting table ,use the following syntax
ALTER TABLE table_name ADD column_name datatype
To Delete or drop a column in a table , use following statement
ALTER TABLE table_name DROP COLUMN column_name
