SAS SQL Constraints-Not Null

nThe NOT NULL constraint enforces a column to NOT accept NULL values.

nThe NOT NULL constraint enforces a field to always contain a value. This means that you cannot insert a new record, or update a record without adding a value to this field.

Query:

CREATE TABLE EMPtbl1
(EMPID int NOT NULL,
EMPname varchar(255) NOT NULL,
company varchar(255),
salary varchar(255),
Location varchar(255))