MySQL Forums
Forum List  »  Newbie

Foreign Keys
Posted by: Wafi Mohtaseb
Date: September 04, 2004 04:03AM

Hi all,

I have these two tables and i want to creat a foreign Key between them

Table 1: MasterTable;

(Object ID P.K,
ObjectName,
ObjectOrder)

Table2: DetailsTable
(ID , ObjectId,Desc)

I want to link these tables by a foreign key and cascade delete option
on the ObjectId Field. I am Using MySQL Veriosn 40.20an-t.
Any one know how can i do this , imean the syntax of the Add constraint

Best Regards.

Options: ReplyQuote


Subject
Written By
Posted
Foreign Keys
September 04, 2004 04:03AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.