1) PRIMARY KEY IS USED AS UNIQUE KEY, FOR AVOID DUPLICATION. 2) FOR VALIDA

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

Question Posted / deepak

Answer Posted / deepak

1) PRIMARY KEY IS USED AS UNIQUE KEY, FOR AVOID DUPLICATION.
2) FOR VALIDATING DATA FROM PRIMARY KEY TABLE FOREIGN KEY USE.

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What are the dmvs? : sql server database administration

1004

What is de-normalization and what are some of the examples of it?

923

Explain the various types of concurrency problem. I.e. Lost or buried updates, uncommitted dependency, inconsistent analysis, phantom read?

885

Can a trigger be created on a view?

895

what is bit datatype? : Sql server database administration

864

When does a workload on SQL Azure get throttled?

129

can you instantiate a com object by using t-sql? : Sql server database administration

961

How to remove duplicate rows from table except one?

939

Explain about integration services of Microsoft SQL server?

982

how you can list all the tables in a database?

967

In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram

1926

What are the properties of the relational tables?

829

Define magic tables in sql server?

988

Explain different backup plans?

881

How many types of subqueries are there in sql server?

934