How to connect PK and FK?

Answers were Sorted based on User's Feedback



How to connect PK and FK?..

Answer / ranjeet

through referential integrity..

Is This Answer Correct ?    12 Yes 0 No

How to connect PK and FK?..

Answer / kalidas vsk

Primary Key is the nothing but index of the table. Foreign
key is dependent of the primary key.

Is This Answer Correct ?    12 Yes 3 No

Post New Answer

More SQL Server Interview Questions

Why should one not prefix user stored procedures with ‘sp_’?

0 Answers  


What is the distinction amongst delete and truncate?

0 Answers  


How to download microsoft sql server 2005 express edition?

0 Answers  


What is the difference between insensitive and scroll cursor?

0 Answers  


What are three ways you can use an identity value inside a trigger? Why would you prefer one way over another?

0 Answers  






Which is better in performance - CONSTRAINT or TRIGGER over a column which restricts say an input of particular value in a column of a table?

3 Answers   Accenture,


You have a table ‘test’ which is a copy of northwind employee table you have written a trigger to update the field ‘hiredate’ with the current date

0 Answers  


How to run sql server 2005 books online on your local system?

0 Answers  


How to list all stored procedures in the current database using ms sql server?

0 Answers  


How will you go about resolving deadlocks?

0 Answers  


What is a partition key?

0 Answers  


what is statistics

1 Answers  


Categories