what is primary key,unique key, foreign key? can u teach me
in simple language?

Answer Posted / patel gopikumar

PRIMARY KEY : it is a key that not allow null value in database tables field....

UNIQUE KEY : it is a key that store or manage data uniquely...

FOREIGN KEY : it is key that use is...connect two fields in the different tables........with foreign key......


thnks........

s-150907-007 PATEL GOPIKUMAR

Is This Answer Correct ?    5 Yes 12 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is data access layer?

1976


Write a query to retrieve for many to many relationships?

569


What are different types of blocks used in stored procedure?

627


What is aws documentdb?

644


Explain normalization in one line?

634






What is difference between clustered, non-clustered and unique index?

601


WHAT IS THE PURPOSE OF TESTING INTEGRITY OF THE UNIVERSE?

1820


can we delete autodiff back up that we have set through sql server agent.

1737


What is the difference between a stored procedure and a query?

588


Given a table of Player which contains Sno and player name, write a query which finds all possible Table Tennis doubles pairings.

921


What is the candidate key used for?

622


What is ole db provider for sql server?

550


What is database schema name?

574


Data structure used to implements a menu:

627


What is the best database?

520