What do you mean by NOT NULL? When will you use it?
Answers were Sorted based on User's Feedback
Answer / s
NOT NULL disallows nulls for the column. Primary Key must
be defined as NOT NULL or any key that you do not want to
have NULLS, becaue the default is that any column can
contain NULLs
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / andank
NOT NULL is the keyword used define columns, when create a
table. When you specify NOT NULL to a column, that column
can not hold NULL values.
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / 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 |
When is the authorization check on DB2 objects done - at BIND time or run time?
What is the purpose of the WHENEVER statement?
What do you mean by between and in? Is between inclusive of specified range values?
How to fetch the last row from the table in SQL (db2)?
What is JOIN and different types of JOIN.
What is the role of data manager in the db2 database?
What is a cursor in programming?
How do you eliminate duplicate values in db2?
What is the difference between oracle and db2?
Which component is responsible for db2 startup and shutdown?
how can we find nth max salary from A table
What is correlation names?