What is Primary key and foreign key? Give an example
Answer Posted / vipin
Primary key which enforce the uniqueness in each row og table .
Foreign key win which the existing value in table must be there in other table .
diffrence is that PK does not allow Null Values anf FK allow null values
| Is This Answer Correct ? | 17 Yes | 2 No |
Post New Answer View All Answers
what happens on checkpoint? : Sql server database administration
What are drilldown reports?
What is the default fill factor value?
What is a constant or literal in ms sql server?
Can you create a logon trigger in sql server 2005 express edition?
explain databases and sql server databases architecture? : Sql server database administration
When would you use sql joins?
Explain the third normal form(3nf)?
What is sql server agent and what are the two modes of authentication in sql server?
Write a Select Query to display title for each group of records, which are collected with Compute Clause? Like titlefield column-A column-B ..... ..... ..... Sum ... titlefield column-A column-B ..... ..... ..... Sum ...
What is transact-sql language?
What is difference between clustered and non clustered index?
How you can get the list of largest tables in a database?
Explain contrast amongst grouped and non-bunched records?
Which tcl commands are available on the sql server?