What is Primary Key?

Answer Posted / satheeh

Primary key is nothing but restriction or condition or constraint given to a specific column to avoid the null and duplicate values.
primary key=not null+unique
that means primary key performs both operations at a time.
primary key plays vital role when relationship between two or more tables

Is This Answer Correct ?    2 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

When is the update_statistics command used?

580


How do I run a query in pl sql developer?

572


Does pl sql work in mysql?

544


What is Materialized View? In What Scenario we Use Materialized View?

8549


how can we encrypt and decrypt a data present in a mysql table using mysql? : Sql dba

652






what is unique key constraint? : Sql dba

584


what is 'trigger' in sql? : Sql dba

572


Explain alias in sql?

594


Explain the purpose of %type and %rowtype data types?

513


What is meant by user defined function?

595


What are the types of records?

549


How many scalar data types are supported in pl/sql?

534


Is sql microsoft?

556


What is use of term?

630


Where is sql database stored?

527