Creating dependant tables in SQL DataBase. 1

[delphiman]

I find that the following does not work in creating a SQL DataBase.

In particular in the IBConsol table CHILD does not show as being dependant upon table PARENT nor does table GCHILD show as being dependant upon table CHILD.

ALTER TABLE CHILD ADD CONSTRAINT FOREIGN KEY (P_NO) REFERENCES PARENT (P_NO);
ALTER TABLE GCHILD ADD CONSTRAINT FOREIGN KEY (C_NO) REFERENCES CHILD (C_NO);

Any suggestions anyone?

 

[svanels]

Try to delete parent wich have a child, you will get an access denied from Interbase.
The IBConsole is very limited in my opinion to show the funcionality of the Database.

With the SQL-explorer I can see the foreign keys and the tables related to Steven van Els
SAvanEls@cq-link.sr

 

[delphiman]

Steven van Els is a genius!!