On Sun, 10 Jun 2001 zilch(at)home(dot)se wrote:
>
> I was just creating this little database for demonstrating the use of
> foreign keys constraints.
>
> I was about the create 3 tables, namely mother, father and child. Mother has
> a foreign key pointing at father ( id ), and father has a foreign key
> pointing at mother ( id ). Child has one pointer to mother ( id ) and one
> pointer to father ( id ). How can I prevent the error message from occurring?
You don't put the constraint at table creation time. The table referenced
by the references has to exist. Use ALTER TABLE to add the constraint
after creating table father.