Interested to Buy Any Domain ? << Click Here >> for more details...
When we can declare a column as Unique and Not Null both at
the same time. What is the use pf Primary Key then?
- 2 Answers
- 17819 Views
- Accenture, Unisoft Infotech, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / thanga prabu.n
Unique Key creates Non-Cluster index in default,
But in Primary Key creates Cluster index in default
| Is This Answer Correct ? | 16 Yes | 1 No |
Answer / swapna
The concept of adding an unique key and not null constraint
to a column as well as adding as unique index to it , you
will assume to get the benefits of adding an primary key
to that column.
But use it for the purpose of referential integrity will
not allow to do so.
That's what PK is so useful. You will use it for
normalization purpose.
| Is This Answer Correct ? | 12 Yes | 6 No |
What is localdb mssqllocaldb?
What schema means?
What is difference between ms sql and mysql?
why not null constraint showing its constraint type as 'c'
discuss about myisam key cache. : Sql dba
Under what condition it is possible to have a page level lock and row lock at the same time for a query? : Transact sql
Why function is used in sql?
How can a pl sql block be executed?
What is difference between group by and partition by?
write a query to find 4th max salary
What are the events on which a database trigger can be based?
How does left join work 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)
