to add a column ----------------------
--------
ALTER TABLE table_name ADD column_name datatype
------------------------------ ------------------------------
delete a column ALTER TABLE table_name
DROP COLUMN column_name ------------------------------
To change data type
------------- -----------------
ALTER TABLE table_name ALTER COLUMN column_name datatype
0 comments:
Post a Comment