Define Foreign Key?
Answer Posted / pravati
foreign key of one table points to a primary key of another table.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
You want to implement the one-to-one relationship while designing tables. How would you do it?
Are connections to sql server encrypted?
Disadvantages of the indexes?
How to create new tables with "create table" statements in ms sql server?
What is the difference between cube operator and rollup operator? : SQL Server Architecture
You have several tables, and they are joined together for querying. The tables contain both clustered indexes and non clustered indexes to optimize performance, how should you distribute the tables and their indexes onto different file groups?
How to get @@error and @@rowcount at the same time?
Why I am getting this error when dropping a database in ms sql server?
What is the contrast amongst drop and truncate?
What is the difference between SQL notification and SQL invalidation?
Explain candidate key, alternate key, and composite key?
What is a unique key constraint?
What is the difference between Stored Procedures and triggers?
Explain forward - only cursors?
How do you rebuild an identity column?