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
Explain the creation and execution of a user-defined function in the sql server?
In case you have filters in your report, when filters will be applied in cached report instance?
How important do you consider cursors or while loops for a transactional database?
How do you Implement SSIS Packages in your Project?
What is a heap?
How to delete duplicate records based on single column from a table?
Can you explain what is indexed view? How to create it?
Which autogrowth database setting is good?
Explain having clause and where clause?
Can you edit the .rdl code associated with a linked report?
how many type of indexing in database?
How to round a numeric value to a specific precision?
Define union, union all, minus, intersect?
What command do we use to rename a db, a table and a column?
How to recreate an existing index in ms sql server?