What is the use of placing primary key and foreign key
constrains on columns.

Answer Posted / rajendraprasad cherukuri

To segregate the data in different tables belongs to a
particular entity so that data can be retrieved when
required more economically and in a faster way.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it? : Sql server administration

647


What is the significance of master, tempdb and model databases?

623


How can you start sql server in different modes?

610


How to write a query with an inner join in ms sql server?

649


What is the difference between locking and multi-versioning?

622






What is efficiency data?

615


How to change the name of a database user?

635


John exports information periodically from a microsoft sql server database to an oracle database what is the best way to do this?

606


When is update_statistics command used?

675


How to disable triggers using "disable trigger"?

659


What are “unrepeatable reads”?

823


Explain the purpose of indexes?

623


How many types of database relationship in sql server?

668


Explain comment on transactions?

645


How to fine-tune reports?

181