SQL NOT NULL

Send request to get interview tips in PDF format Personal Interview - Answers to frequently asked questions Tips to earn promotions and perks You can also get your answers published How to write a good CV? How to write a good Cover Letter? Tips to become boss's favorite CareerRide is hiring

SQL NOT NULL - Introduction and syntax

---

<<Previous  Next>>

SQL - Dec 03, 2008 at 18:00 PM by Rajmeet Ghai

Explain the SQL NOT NULL statement. Write SQL syntax for the SQL NOT NULL statement along with an example.

SQL NOT NULL: The NOT NULL constraint enforces a column to NOT accept NULL values. This means a column with not null always needs to have a value. This means that you cannot insert a new record, or update a record without adding a value to this field

Example:

CREATE TABLE employee
(
     Emp_id int NOT NULL,
     LastName varchar(255) NOT NULL,  
     FirstName varchar(255),
     Address varchar(255),
     City varchar(255)
)

<<Previous  Next>>