ALTER TABLE examples

The following statement adds a column:

ALTER TABLE "employee.dbf" ADD BUILDING_NO SMALLINT

The next statement drops two columns:

ALTER TABLE "employee.db" DROP LAST_NAME, DROP FIRST_NAME

The following statement drops two columns and adds one:

ALTER TABLE "employee.dbf" DROP LAST_NAME, DROP FIRST_NAME, ADD FULL_NAME CHAR(30)