What is Primary Key?
Answers were Sorted based on User's Feedback
Answer / ashis kumar jena
A primary key is one which uniquely identifies a row
of a table.
This key does not allow null values and also
does not allow duplicate values.
Each table should have a primary key, and each table can
have only one primary key.
| Is This Answer Correct ? | 16 Yes | 2 No |
Answer / perumal
1. Primary Key Doesn't allow the NULL values and also
does not allow duplicate values.
2. Primary Key has the Unique Columns.
3. Primary Key Uniquely Identify the each row of the tables.
| Is This Answer Correct ? | 14 Yes | 3 No |
Answer / hannan oca
primary key =notnull+unique value in column
a table consist of only one primary key.
Example
a primary key is like a father in house, like only one but
there may be a lot of childs just like columns.
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / 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 |
How do I edit a trigger in sql developer?
Authentication mechanisms in Sql Server ?
How do I view a procedure in sql?
How many types of literals are available in pl sql?
What are the different types of functions in sql?
What is the difference between python and sql?
What is sql partition function?
What is synchronized subquery?
What is anonymous block in sql?
What is meaning of <> in sql?
write a query filter the null value data following source? name age john 30 smith null null 24 sharp 35 i want output name age john 30 sharp 35
What are the different dcl commands in sql?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)