Deleting or Modifying a Table

Deleting: DROP Person;

Altering: (adding or removing an attribute).

ALTER TABLE Person

ADD phone CHAR(16);

ALTER TABLE Person

DROP age;

What happens when you make changes to the schema?

Previous slide

Next slide

Back to first slide

View graphic version