Question: Change the Appointments table so when a APPOINTMENT _ ID is added a PET _ ID must be added. Select the correct SQL . a

Change the Appointments table so when a APPOINTMENT_ID is added a PET_ID must be added. Select the correct SQL.
a. MODIFY TABLE Appointments
MODIFY (PET_ID INTEGER NOT NULL);
b. CHANGE TABLE Appointments
MODIFY (PET_ID INTEGER NOT NULL);
c. ALTER TABLE Appointments
MODIFY (PET_ID INTEGER NOT NULL);

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!