what is the different between unique+not null & primary key,
Answer Posted / 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 |
Post New Answer View All Answers
What is left join in postgresql?
Explain the advantages and disadvantages of stored procedure?
What is sql partition?
What is sql in java?
If a cursor is open, how can we find in a pl/sql block?
How do I access sql anywhere database?
What is pl sql variable?
What is crud sql?
how to load data files into tables with 'mysqlimport'? : Sql dba
What is coalesce sql?
How do I create a memory optimized filegroup?
what are all types of user defined functions? : Sql dba
What is a clob in sql?
Is sql port 1433 encrypted?
Are null values same as that of zero or a blank space?