Am i right in thinking that a relation database is only in the mind...
I mean i know you can link table using sql commands but is there an sql command to create a relationship between 2 tables, like ACESS does so that i can cascade delete on things?
-----------------------------------
edit worked it out myself dont worry
if anyone cares here is a lot of sql
CREATE TABLE site
(
ID INT NOT NULL,
Name VARCHAR(30) NOT NULL,
CONSTRAINT spk1 PRIMARY KEY (ID)
);
CREATE TABLE area
(
ID INT NOT NULL,
siteID INT NOT NULL,
Name VARCHAR(20) NOT NULL,
CONSTRAINT apk1 PRIMARY KEY (ID),
FOREIGN KEY (siteID) REFERENCES site(ID) ON DELETE CASCADE
);
CREATE TABLE cell
(
ID INT NOT NULL,
areaID INT NOT NULL,
Name VARCHAR(20) NOT NULL,
CONSTRAINT cpk1 PRIMARY KEY (ID),
FOREIGN KEY (areaID) REFERENCES area(ID) ON DELETE CASCADE
);
CREATE TABLE rack
(
ID INT NOT NULL,
cellID INT NOT NULL,
Name VARCHAR(20) NOT NULL,
CONSTRAINT rpk1 PRIMARY KEY (ID),
FOREIGN KEY (cellID) REFERENCES cell(ID) ON DELETE CASCADE
);
CREATE TABLE shelf
(
ID INT NOT NULL,
rackID INT NOT NULL,
Name VARCHAR(20) NOT NULL,
CONSTRAINT spk1 PRIMARY KEY(ID),
FOREIGN KEY (rackID) REFERENCES rack(ID) ON DELETE CASCADE
);
CREATE TABLE bin
(
ID INT NOT NULL,
shelfID INT NOT NULL,
Name VARCHAR(20) NOT NULL,
CONSTRAINT bpk1 PRIMARY KEY(ID),
FOREIGN KEY (shelfID) REFERENCES shelf(ID) ON DELETE CASCADE
);
----------------------
it was setting up the foreign key references that i was trying to do.