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

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

Question Posted / rajkumar

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

Please Help Members By Posting Answers For Below Questions

Can you create a logon trigger in sql server 2005 express edition?

1061

How can you list all the table constraints in a database?

919

Can multiple columns be used in sql group by clause in ms sql server?

1027

What is the difference between Stored Procedures and triggers?

1066

What is log shipping? Can we do logshipping with SQL Server 7.0 ?

960

What are the differences between ms sql server & oracle?

1036

How to attach adventureworkslt physical files to the server?

1087

What should be the fill factor for indexes created on tables? : sql server database administration

1119

Explain what are the events recorded in a transaction log?

986

Explain Capacity planning to create a database? and how to monitor it?

4176

What is triggers in ms sql server?

1091

How to list all user names in a database?

1035

Is it possible in sql table to have more than one foreign key?

1014

How to display a past time in days, hours and minutes?

1003

what stored procedure can you use to display the current processes? : Sql server administration

992