Modifying tables
Here’s an example of a table modification:
ALTER TABLE CUSTOMER
ADD COLUMN Email CHAR (50) ;
ALTER TABLE CUSTOMER
DROP COLUMN Email;
Here’s an example of a table modification:
ALTER TABLE CUSTOMER
ADD COLUMN Email CHAR (50) ;
ALTER TABLE CUSTOMER
DROP COLUMN Email;