It seems like I am having a bad day! can any please please point at the mistake in the following peice of code.
CREATE TABLE Sale (
saleid integer NOT NULL,
clientid integer NOT NULL,
productid integer NOT NULL,
saledate datetime NOT NULL,
CONSTRAINT pk_sale_id primary key (saleid),
CONSTRAINT fk_client__clientid_sale FOREIGN KEY (clientid)
REFERENCES Client(clientid) ON DELETE CASCADE,
CONSTRAINT fk_product_pid_sale FOREIGN KEY (productid)
REFERENCES Product(pid)
);
I get the following error
Server: Msg 156, Level 15, State 1, Line 14
Incorrect syntax near the keyword 'ON'.
TIA,
Saurabh