Interested to Buy Any Domain ? << Click Here >> for more details...
what is the different between unique+not null & primary key,
- 4 Answers
- 7764 Views
- I also Faced
- E-Mail Answers
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 are the different tables present in mysql, which type of table is generated when we are creating a table in the following syntax: create table employee (eno int(2),ename varchar(10)) ? : Sql dba
What is a unique key and primary key and foreign key?
What are the different schemas objects that can be created using pl/sql?
Explain spool.
Is sql sequential or random?
What is information schema in sql?
Can you call pl/sql package functions from within a fast formula?
what is schema? : Sql dba
How can you select unique records from a table?
Why is sql*loader direct path so fast?
What is sql trigger example?
Is oracel sql developer written in java?
What is form and report?
does sql support programming? : Sql dba
Does sql backup shrink transaction log?
