what is the different between unique+not null & primary key,
- 4 Answers
- 7087 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints
What are primary key and foreign key and how they work?
give the syntax of grant and revoke commands? : Sql dba
how tsql statements can be written and submitted to the database engine? : Transact sql
How many rows can sqlite handle?
how to get @@error and @@rowcount at the same time? : Sql dba
How do I tune a sql query?
Is it possible to link two groups inside a cross products after the cross products group has been created?
What is difference between inner join and self join?
What is difference between mysql and postgresql?
difference between anonymous blocks and sub-programs.
What is synchronized subquery?
What is database migration?
What is autocommit sql?
What is cursor explain with example?
