CIS 336 STUDY Great Stories/cis336study.com CIS 336 STUDY Great Stories/cis336study.com | Page 60

Phone
Employer
Registration_Date
FK1Zip
Enrollment
PK,FK1Section_ID
PK,FK2Student_ID
Enroll_Date
Final_Grade
LAB STEPS
STEP 1: The DROP Statements
A DROP TABLE statement must appear in your script file, prior to the
SQL statements for creating
the table in question. This will allow you to run and re-run your script
file as often as you need to. The
very first time you run your script the table does not exist, so the IF
EXISTS clause causes the statement
to be ignored. Thereafter, the table will be deleted, ensuring that your
CREATE TABLE statement creates
the table fresh and clean, with only the attributes present in the
current revision of the CREATE
statement. Here is an example of one of the six DROP TABLE
statements you will need to create.