What is Primary key and foreign key? Give an example
Answer Posted / alquama rizvi
MS-Access requires a special way of recognising every record of a table. For this you have to set or make a primary key. If you do not do so, MS-Access does this itself by adding a new field , serving as the primary key. A table may have only one primary key, although it may have more than one fields.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to check parameter value in stored procedure sql server?
Do you know what is difference between index seek vs. Index scan?
What is the correct order of the logical query processing phases?
what is unique and xaml nonclustered index
How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?
Explain aggregate functions?
Explain trigger classes i.e. Instead of and after trigger?
How can I create a report based on a query? : sql server management studio
Can you explain what is indexed view? How to create it?
What are the export options of ssrs?
What are null values in ms sql server?
What happens if we shrink log file in sql server?
How do you create a data source?
What is log in sql server?
What are diverse clauses that form a part of sql?