what is the different between unique+not null & primary key,
Answers were Sorted based on User's Feedback
Answer / sreekumar
In a relation, we can create only one primary key where as we can create multiple unique+not null constrains.
Primary key uses clustered index where are unique +Not null uses non clustered index.
Sreekumar
| Is This Answer Correct ? | 18 Yes | 1 No |
Answer / suresh babu
Unique:
Unique is a constraint,which doesn't allow the duplicate
values and allow only one null value.We can create more
number of unique constraint in single table.
Not Null:
Not Null constraint,which doesn't allow the Null values and
allow the duplicate values.
Primary Key:
We can create one primary key for a table,Which doesn't
allow the duplicate and null values,and used for make a
foreign key relation.we can't do this process using above
two constraints.
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / mohan babu
A unique key is nothing but it does not allow any
duplicateds but allows nullvalues
A primary key is nothing but it does not allow duplicates
as well as Null values i.e Not Nulls
| Is This Answer Correct ? | 5 Yes | 5 No |
Answer / giri
unique:it does not allow duplicate values but it allow null values.
not null:It does not allow null values but allow duplicate values.
primary:It does not allow both duplicate and null values.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is pl sql code?
What is the difference between sql and mysql?
Give which cursor is better for better performance means type of cursors?
Is join same as left join?
What is the command used to fetch the first 5 characters of a string?
What is sql analyzer?
How to count the no of records of a table without using COUNT function?
What are the modes of parameters that can be passed to a procedure ?
what is self join and how it works??
Can we call dml statement in function?
What is a pl/sql block?
i have a word ***********hello********world******. I require a o/p **********hello world**********, Need to delete the middle stars.
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)