Re: help with add constraint syntax needed

On Wed, 20 Jun 2001, Mike Haberman wrote:

> hello all,
>
> I am using an xml -> sql generator where foreign key are specified
> after the columns are. The sql is written as the xml file is being
> parsed so, the foreign key stuff must be written after the fact.
>
> The problem I need to solve is adding the on Delete/on Update constraints.
>
> here's what I would like to do (e.g.):
>
> ALTER TABLE league
> ADD CONSTRAINT leagueOwnerId FOREIGN KEY (leagueOwnerId)
> REFERENCES TeamOwner (id) ON DELETE CASCASE;
>
> table teamOwner (id)
> table league (id, leagueOwnerId)
> where leagueOwnerId is a FKey to owner(id)

What problem are you having? The above works for me assuming teamowner
has a unique constraint on id on current sources.