Add a column to a table in the database:
ALTER TABLE table_name
ADD column_name datatype
Delete a column from a table in the database:
ALTER TABLE table_name
DROP COLUMN column_nameuseful tidbits for using open source software in science
Add a column to a table in the database:
ALTER TABLE table_name
ADD column_name datatype
Delete a column from a table in the database:
ALTER TABLE table_name
DROP COLUMN column_name