What do you mean by NOT NULL? When will you use it?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is the responsibility of the construction superintendent

1660


Mention the location where the output received from explain statement is stored.

628


What is the advantage in De-normalizing tables in DB2?

743


Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?

624


List out the data types available.

697






What is db2 purescale?

543


How to resolve deadlock issue

17951


What is db2 bind?

636


How do I add a column to an existing table in db2?

588


How do I change the column size in db2?

587


Can we update view in db2?

555


What does runstats do in db2?

607


What is the function of logging in the db2 database?

638


What does db2 stand for?

596


What is concurrency?

709