[SQL] Parent table has not oid?

Dear All: Please disregerd my last email. I want to create a delete cascade in children tables. The primary key of parent table is oid. CREATE TABLE Link ( Protein_ID oid CONSTRAINT one REFERENCES Protein (oid) ON DELETE CASCADE, Link varchar(128) ); Create child table is ok.

[SQL] table protein does not have an attribute oid? why?

Dear All: I want to create a delete cascade in children tables. The primary key of parent table is oid. CREATE TABLE Link ( Protein_ID oid, Link varchar(128) CONSTRAINT one REFERENCES Protein (oid) ON DELETE CASCADE ); Create child table is ok. When I insert a record in

[SQL] No promany key in parent table, how to use delete cascade?

"PRIMARY KEY for referenced table "parent" not found" I do not need to specify the primary key since I am using oid. How can I get around this problem? Thanks. Zhidian Du _ MSN 8 with e-mail virus protection

[SQL] Delete cascade for multi tables?

the releated records in the referecne table. How can I create reference table? Thanks. Zhidian Du _ Help STOP SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail