Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between primary key & unique index ?
- 6 Answers
- 27016 Views
- Patni, Temenos, I also Faced
- E-Mail Answers
Answer Posted / palash ghosh
1)Primary key creates an implicit culstered index on a
table, unique key does not create any implicit index.
2)Columns defined as primary key does not allow null values,
where as columns defined as unique can allow null values.
3)A table can have just one primary key (can be a composite
key) where as there can be multiple unique columns (keys).
4)Primary key is a unique key with the above mentioned
features.
| Is This Answer Correct ? | 9 Yes | 1 No |
Post New Answer View All Answers
List down the data types in the db2 database.
What do you mean by commit and rollback?
How can you find out the # of rows updated after an update statement?
What is the difference between cursor stability and repeatable read isolation levels?
What are the 2 sqlcodes that are returned?
What is the physical storage length of date data type?
How do I start db2 in windows?
Define sqlca.
What is a db2 tablespace?
How do you pull up a query which was previously saved in qmf?
What is with ur in db2?
i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?
What does db2 plan contain?
What is dbrm? When it will be created?
How to get the ddl of a table in db2?
