Question: On line 6, Please fix the error for me: it reads: constraint is not valid at this position expecting ' ) ' 3 2. CREATE

On line 6, Please fix the error for me: it reads: "constraint" is not valid at this position expecting ' ) '

On line 6, Please fix the error for me: it reads: "constraint"

3 2. CREATE TABLE phone (phone_id INT primary key, country_code INT NOT NULL, phone_no INT NOT NULL, phone_type VARCHAR(12) CHECK (phone_type in('Home', 'Office', 'other')), 4 store_id INT, customer_id INT, staff_id INT, 5 constraint fk foreign key (store_id) REFERENCES store (store_id) ON UPDATE CASCADE ON DELETE SET NULL 60 constraint fk foreign key (staff_id) REFERENCES staff(staff_id) ON UPDATE CASCADE ON DELETE SET NULL constraint fk foreign key (customer_id) REFERENCES customer(customer_id) ON UPDATE CASCADE ON DELETE SET NULL); 8. ALTER table address drop column phone; 7

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!