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
How many tables can be joined in SQL Server?
I have triggers,views,functions,stored Procedures for a table. When I am dropping that table which objects are deleted?
what are defaults? : Sql server database administration
what are database files and filegroups? : Sql server database administration
what are the types of indexes? : Sql server database administration
Tell me what do you mean by an execution plan? Why is it used? How would you view it?
what changed between the previous version of sql server and the current version? : Sql server database administration
How many clustered indexes can be created on a table? I create a separate index on each column of a table. what are the advantages and disadvantages of this approach?
What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?
What language is sql server written in?
What are the types of database schema? : sql server analysis services, ssas
What is subreport?
Can we use trigger new in before insert?
Explain “row_number()” in sql server with an example?
Do you know what are acid properties of transaction?