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

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 (DOT) com> wrote

i am using sql server 2000.i know about alter table but if u can wrtite
query and display to me it will be good for me. as i know the formate of
alter table but for composite primary key i am not able to do it.







Originally posted by Bob Badour




--
Posted via http://dbforums.com

Try
comp.databases.ms-sqlserver
or
microsoft.public.sqlserver.*

--
- Anith
( Please reply to newsgroups only )