Re: Adding a Foreign Key Reference to a table

Rob Cole wrote:
>
> Is it possible to add a foreign key reference to a table using the ALTER TABLE
> command. I have tried to find examples of this in the documentation with no
> success.
>
> Rob Cole (rcole_at_cellnet.co.uk):-|

Try

ALTER TABLE table ADD FOREIGN KEY (column) REFERENCES ptable(column);

         James H. Yoshii
 IntelliTech Business Solutions

        yoshii_at_planet.net