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

How to provide column names in insert statements in ms sql server?

1228

You want to implement the many-to-many relationship while designing tables. How would you do it?

1050

How to count rows with the count(*) function in ms sql server?

1062

What is key set driven?

1011

What is the use of partition by in sql server?

972

Explain the dbcc pintable command when would you use it?

971

what's sql server? : Sql server database administration

1053

Can I save my report as html, excel or word? : sql server management studio

1013

What is the command used to recompile the stored procedure at run time?

1120

What is scalar user-defined function?

1189

How to create function with parameter in sql server?

1158

What is built-in/administrator?

1078

Does index slows down insert statements?

1047

What is etl - extraction, transformation, and loading?

961

Explain system functions or built-in functions? What are different types of system functions?

1042