Question: Create the SQL code for the table below Hint: Multiple ways exist to do things in SQL two ways to define foreign keys: one is
Create the SQL code for the table below
Hint: Multiple ways exist to do things in SQL two ways to define
foreign keys: one is to define foreign key within the CREATE
TABLE statement, for example:
CREATE TABLE products
productid numeric not null, supplierid numeric
CONSTRAINT fksupplier FOREIGN KEY supplierid
REFERENCES suppliersupplierid ON DELETE SET NULL
Another way is to create table without defining foreign key and add
foreign key later using the ALTER TABLE statement sometimes you
might have to do like this for example:
ALTER TABLE Products ADD CONSTRAINT fksupplier
FOREIGN KEY supplierid REFERENCES suppliersupplierid
ON DELETE SET NULL
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
