and also a ; is needed after -- ALTER TABLE i.tblsitegroups DROP CONSTRAINT > fk_tblsatellitemanager_tblsites_fk
On Wed, 2003-07-02 at 11:47, John Bercik wrote: > Hi, My sql appears to be missing my "i" schema. I believe it should > be "REFERENCES i.tblsites". When I make it with "i." it works fine. > Thanks for any ideas. > John > > -- Foreign Key: i.fk_tblsatellitemanager_tblsites_fk > > -- ALTER TABLE i.tblsitegroups DROP CONSTRAINT > fk_tblsatellitemanager_tblsites_fk > > ALTER TABLE i.tblsitegroups > ADD CONSTRAINT fk_tblsitegroups_tblsites_fk FOREIGN KEY (maskedsiteid) > REFERENCES tblsites (maskedsiteid) ON UPDATE CASCADE ON DELETE CASCADE; -- Best regards, John Bercik E-Mail: [EMAIL PROTECTED] Systems Programmer Office: 843/792-1715 Medical University of South Carolina Fax: 843/792-0816 Room 826F Clinical Science Building 76 Jonathan Lucas Street Charleston, SC, USA 29425 ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
