What is the use of placing primary key and foreign key
constrains on columns.
Answer Posted / jagadeesh b
If you maintain this relation ship you can get more advantages
1)you can not delete primary table directly..
2)duplicate values are not allowed in primary key table.
3)Null values are not inserted into primary key table so
validation is very easy fro m front end.(for ex; .net 2005).
Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is the difference between NOROW and LOCKROW?
What is the difference between commit and rollback?
Write a query to find 5th highest amount paid from the customer table.
When do you think a developer should use sql server-based cursors?
Would you store your query in a ssrs report or a database server? State the reason why?
What is a data collection table?
How will you add a dimension to cube? : sql server analysis services, ssas
How to replace null values in expressions using isnull()?
Can sql server 2016 run on windows 7?
Explain collation?
Explain what stored procedure sp_replcounters is used for? : sql server replication
How to drop an existing table with "drop table" statements in ms sql server?
which backup strategy you are following at ur company
What causes index fragmentation?
What are the disadvantages of merge replication?