Interested to Buy Any Domain ? << Click Here >> for more details...
What is the use of placing primary key and foreign key
constrains on columns.
- 4 Answers
- 8490 Views
- Value Labs, I also Faced
- E-Mail Answers
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
optimization techinques
What are the character string functions supported by sql server 2005?
Define outer join?
What happens if time-only values are provided as date and time literals?
what kind of lan types do you know? : Sql server database administration
What is function of CUBE ?
What are the two modes of authentication in sql server?
How check triggers in sql server?
What is use of @@ spid in sql server?
Explain timestamp datatype?
As a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this?
What is mscorsvw.exe - process - microsoft .net framework ngen?
Do you have any idea about the tcl commands?
what is a sub-report?
What is subreport?
