answersLogoWhite

0

What is meant by a mandatory field?

Updated: 12/22/2022
User Avatar

Wiki User

16y ago

Best Answer

a mandatory field in a database is one created in a table as "Not null". This means, there is a "rule" on the field that when data is inserted into the table, this field cannot be empty. If it is, then the insert errors. Here's part of a table definition in my database. These field are are required to be populated when inserting into this table. ATTR_DESC_01 CHAR(2) DEFAULT SYSTEM NOT NULL
, ATTR_DESC_02 CHAR(2) DEFAULT SYSTEM NOT NULL
, ATTR_DESC_03 CHAR(2) DEFAULT SYSTEM NOT NULL
, ATTR_DESC_04 CHAR(2) DEFAULT SYSTEM NOT NULL
, ATTR_DESC_05 CHAR(2) DEFAULT SYSTEM NOT NULL
, ATTR_DESC_06 CHAR(2) DEFAULT SYSTEM NOT NULL
, ATTR_DESC_07 CHAR(2) DEFAULT SYSTEM NOT NULL
, ATTR_DESC_08 CHAR(2) DEFAULT SYSTEM NOT NULL
, ATTR_DESC_09 CHAR(2) DEFAULT SYSTEM NOT NULL
, ATTR_DESC_10 CHAR(2) DEFAULT SYSTEM NOT NULL
, PARTITION_NBR SMALLINT NO DEFAULT NOT NULL
)

User Avatar

Wiki User

16y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: What is meant by a mandatory field?
Write your answer...
Submit
Still have questions?
magnify glass
imp