Q. Add a constraint (NN-Grade) in table Empl that declares column Grade not null.
Table --
Answer =
Alter table Empl add column grade int(1) Not null ;
Table --
Answer =
Alter table Empl add column grade int(1) Not null ;
Table --
Answer =
Alter table Empl add column grade int(1) Not null ;
Can we do like this??
ReplyDeletealter table Empl add Constraint NN-Grade (Grade Not Null);
Ye
DeleteNo modify is required statement.
ReplyDelete??
DeleteQuestion has demanded for adding a constraint . So "ADD constraint nngrade CHECK(grade IS NOT NULL)" Should be the correct query.. Isn't it?
ReplyDeleteNo, We have to add column "Grade".
Deletecan we write this as
ReplyDeleteALTER TABLE Empl
modify Grade
ADD constraint NN-Grade check(Grade IS NOT NULL);
Post a Comment
You can help us by Clicking on ads. ^_^
Please do not send spam comment : )