what is difference between primary key and unique key
?
Answer Posted / chandonline
Basic difference between primary key and unique is that primary key is used to define a table in other tables for preventing data from anomalies,and unique key is used in a table to apply unifications among different values or columns of a tables and only in that table obviously.Their is no usage of unique key outward a table but primary key is often used to make relations between other tables.
Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Explain about relational database management systems?
How long can an error message be in raiseerror function?
State the acid rules?
You have two tables with a one to many join based on a field named id. You need to find records in the parent table that are not represented in the child table. how would you accomplish this?
Explain about the relational database?
What are the key features of dbms?
What is dbms explain in brief?
Explain about the database management systems.
Explain the role of indexing in databases?
Explain the cube operator?
If a column is an image value type, how you can compare column values? How can you use this column in join clause?
fact table and dimension table containg one to many relationship or many to one relastionship
What is the database development process?
What are the 18 schemas?
Write short notes on manual refreshes.