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

Answer Posted / monal

TO CREATE REFERENTIAL INTEGRITY BETWEEN 2 TABLE.

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are pages and extents? : SQL Server Architecture

643


When I delete any data from a table, does the sql server reduce the size of that table?

659


Which is better statement or preparedstatement?

618


What is the purpose of the model database?

671


Why is normalisation important?

594






How to define and use table alias names in ms sql server?

655


Explain about sql server login?

690


Is truncate autocommit?

639


What are diverse clauses that form a part of sql?

681


What is the purpose of object explorer and its features? : sql server management studio

713


can a database be shrunk to 0 bytes, if not, why? : Sql server administration

702


What are logical/boolean operations in ms sql server?

619


Which are ddl commands?

623


What area unit the various kinds of info compression introduced in sql server 2008?

657


What is the most common type of join?

625