Re: I simply can't compile this

"Morten Gulbrandsen" <[EMAIL PROTECTED]> wrote: > [skip] > ALTER TABLE EMPLOYEE # here is the buggy code > ADD FOREIGN KEY (DNO) REFERENCES DEPARTMENT(DNUMBER) > ON DELETE SET DEFAULT > ON UPDATE CASCADE; > > ALTER TABLE DEPARTMENT > ADD FOREIGN KEY (MGRSSN)REFER

AW: I simply can't compile this

. August 2003 12:05 An: [EMAIL PROTECTED] Betreff: I simply can't compile this CREATE TABLE EMPLOYEE ( FNAME VARCHAR(15) NOT NULL, MINIT CHAR, LNAME VARCHAR(15) NOT NULL, SSN CHAR(9) NOT NULL, BDATE DATE, ADDRESS VA

I simply can't compile this

CREATE TABLE EMPLOYEE ( FNAME VARCHAR(15) NOT NULL, MINIT CHAR, LNAME VARCHAR(15) NOT NULL, SSN CHAR(9) NOT NULL, BDATE DATE, ADDRESS VARCHAR(30), SEX CHAR, SALARY DECIMAL(10,2), SUPERSSNCHAR(9), DNO