Computer Science
Can a column defined with NOT NULL constraint, be skipped in an INSERT command ?
DDL & DML
1 Like
Answer
If a column defined with a NOT NULL constraint is skipped in an INSERT command, it will result in an error, and the row will not be added to the table.
Answered By
1 Like
Related Questions
What is NOT NULL constraint ? What is DEFAULT constraint ?
When a column's value is skipped in an INSERT command, which value is inserted in the database ?
How would you view the structure of table Dept ?
Table Empl has same structure as that of table EMPL. Write a query statement to insert data from table NewEmpl into EMPL where salary and comm is more than Rs. 4000.