why can't we assign not null constraint as table level constraint

why can't we assign not null constraint as table level
constraint

Question Posted / itlumeeprasad

3 Answers
12646 Views
CTS, Wipro, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

why can't we assign not null constraint as table level constraint..

Answer / lokanath

Because its a Column Level constraint.
Not Null is a Constraint which will ensure the Column
should not be null.

Is This Answer Correct ?

10 Yes

12 No

why can't we assign not null constraint as table level constraint..

Answer / senthil

not null constraint applied on table level constraint but table must be empty otherwise not possible .

Is This Answer Correct ?

0 Yes

3 No

why can't we assign not null constraint as table level constraint..

Answer / newton_dba

A NOT NULL CONSTRAINT IS USAUALLY APPLIED ON COLUMN LEVEL
BUT IT CAN BE APPLIED ON THE TABLE LEVEL BY USING ALTER
TABLE STATMENT

ALTER TABLE EMP
MODIFY (ENAME CONSTRAINT EMP_ENAME_NN NOT NULL);

Is This Answer Correct ?

7 Yes

13 No

Post New Answer