• September 29, 2014
  • SQL
  • Comments Off on SQL NOT NULL Constraint

SQL NOT NULL Constraint

The NOT NULL constraint enforces a field or column to not contain a null value.

Example of NOT NULL constraint with CREATE TABLE statement:

CREATE TABLE PERSONS (
 
P_ ID INT NOT NULL,
 
NAME VARCHAR (20) NOT NULL,
 
AGE INT,
 
PRIMARY KEY (P_ID)
 
);

Example of NOT NULL constraint with ALTER TABLE statement:

ALTER TABLE PERSONS MODIFY AGE INT NOT NULL;

 
Next Topic: SQL UNIQUE Constraint with example.
Previous Topic: SQL FOREIGN KEY with example.

Related Topics:

How to build java project using ant in eclipse?
JAXB marshalling – convert java object to xml example.
How to create pdf file in java using iText jar?
Generics class example.
OGNL in struts 2.
Hibernate One-to-One Mapping using xml.
Send inline image in email using JavaMail API.
Quartz 2 JobListener example.

 


Comments are closed.