If any possiable to use 2 primary key in single table?
How many primary key & foreign key used in each table(min &
max)?

Answer Posted / rajkumar

A table can have only one foreign key and 253 foreign keys can have in a single table.

Is This Answer Correct ?    2 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is use of @@ spid in sql server?

876


Explain what are the events recorded in a transaction log?

730


How to add a new column to an existing table with "alter table ... Add" in ms sql server?

755


What are the types of table?

735


What is command parameter in ssrs?

141






How to convert a numeric expression from one data type to another?

695


Difference between drill down and drill through report.

726


What is mean by dml?

734


Explain about integration services of Microsoft SQL server?

772


What is the purpose of self join?

663


What are a database and a data warehouse?

739


What is difference between equi join and inner join?

649


What are “phantom rows”?

1407


What is database white box testing?

839


How do database indexes work?

716