Re: how to set composite key as foreign key?

You don't mention the product you are using. Regardless, I suggest you open the manual and look for "ALTER TABLE".

"rupali007" <member38432_at_dbforums.com> wrote in message news:3339785.1062916039_at_dbforums.com...
>
> hi freinds,
>
>
>
> i want to set any composite primary key in given table as foreigen key
> by sql query not by enterprise manager.
>
>
>
> suppose i have library as databse and two tables as
>
> books(cAccnumber,ctitle,cedition)
>
> issuedetails(cAccnumber,cMembercode,dDateofissue)
>
>
>
> wher cAccnmuber is primary key in books and cAccnumber,cMembercode as
> composite primary key in issuedetails.so if i want set cAccnumber as
> foreign key then what will be query structure.
>
>
>
> this is possible using enterprise manager but i want to do it by code.so
> help me if u have any idea.
>
>
>
> thanks
>
>
> --
> Posted via http://dbforums.com
Received on Sun Sep 07 2003 - 13:06:44 CEST