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 ' ) '

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
Get step-by-step solutions from verified subject matter experts
