MySQL Forums
Forum List  »  Partitioning

Re: foreign key in partition
Posted by: Aftab Khan
Date: December 24, 2010 11:09AM

Foreign keys not supported. Partitioned tables do not support foreign keys. More specifically, this means that the following two statements are true:

1.

Definitions of tables employing user-defined partitioning may not contain foreign key references to other tables.
2.

No table definition may contain a foreign key reference to a partitioned table.

Options: ReplyQuote


Subject
Views
Written By
Posted
4228
December 24, 2010 06:02AM
Re: foreign key in partition
1740
December 24, 2010 11:09AM
1562
December 25, 2010 01:25AM


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.