Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started