Click here to Skip to main content
15,908,013 members
Please Sign up or sign in to vote.
2.00/5 (1 vote)
See more:
I am doing a past exam paper and i don't have the answer, can anyone tell me if this is correct.
The Question is : Make the AU_ID and the ISBN the Primary Key of the BOOK_AUTHOR table

My answer : ALTER TABLE BOOK_AUTHOR
ADD CONSTRAINT PK_BOOK_AUTHOR Primary Key CLUSTERED (AU_ID),(ISBN)
Posted
Comments
Tim Corey 20-Nov-12 13:09pm    
Have you tried it out on a database? That would tell you for sure and it would be more instructive than a simple yes/no from us.
yu2ish 20-Nov-12 13:16pm    
Oh sorry i forgot to mention, my sql server has stopped responding --'
instead of wasting more time on trying to repair it or i thought of using that time in trying to work out the questions.

1 solution

Here is the correct query that works.

SQL
ALTER TABLE BOOK_AUTHOR ADD CONSTRAINT PK_BOOK_AUTHOR Primary Key CLUSTERED (AU_ID,ISBN)
 
Share this answer
 
v2

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900