Explain alternate key, candidate key and composite key in sql server?
- 1 Answers
- 992 Views
- I also Faced
- E-Mail Answers
Answer Posted / Mohd Arif Usman
In SQL Server, a Candidate Key is a column or set of columns that can uniquely identify each row in a table. An Alternate Key is another set of columns that can also be used to uniquely identify the rows, but it's not the primary key. A Composite Key is a combination of two or more columns that together form a unique identifier for each row.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the primary use of the model database?
Can you index views?
Why use identity in sql server?
What is a scheduled job or what is a scheduled task?
Why and when do stored procedure recompile?
How to convert character strings into numeric values?
List the ways in which dynamic sql can be executed?
What is clustered index
What is a view in sql?
How efficient you are in oracle and SQL server?
What are the different types of subquery?
What are the source of constraints?
How can we solve concurrency problems?
explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
Where can you add custom error messages to sql server?
