CREATE TABLE vendor ( vendor_id int NOT NULL, vendor_name char(50) NOT NULL, con

Question

CREATE TABLE vendor

( vendor_id int NOT NULL,

vendor_name char(50) NOT NULL,

contact_name char(50),

CONSTRAINT vendors_pk PRIMARY KEY (vendor_id) );

I cant find the foreign key for this table?

I cant find the foreign key for this table?

create table Inventory(I_Flower_Name varchar(20) ,I_FlowerNumber number , I_Location varchar(20), I_Condition varchar(20), I_Search varchar(40),I_Delete varchar(20), I_Add number,I_Quantity number,PRIMARY KEY
(I_Flower_Name,I_FlowerNumber));

I am having trouble adding the foreign key into all three tables?

Explanation / Answer

vendor_id int,

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects