Interested to Buy Any Domain ? << Click Here >> for more details...
What do you mean by NOT NULL? When will you use it?
- 3 Answers
- 6669 Views
- I also Faced
- E-Mail Answers
Answer Posted / s
CREATE UNIQUE WHERE NOT NULL INDEX index1
ON table(column);
WHERE NOT NULL ensures that non-null values are unique.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How do you concatenate the firstname and lastname from emp table to give a complete name?
What is explain in db2?
What is runstats and reorg in db2?
Which command is used to remove all rows from a table?
Are view updateable?
Which isolation level provides highest data integrity?
What is the use of db2 optimizer?
What is buffer pool in the db2 database?
Define sqlca.
What is the usage of open cursor command?
What is an instance in db2?
What is phantom read in db2?
How do we specify index to include or not during bind process.
How can tablespace be moved to another dasd volume that is allocated for that tablespace?
What is the information associated with sysibm.syslinks table?
