2015. 6. 11. 10:42
http://www.w3schools.com/sql/sql_notnull.asp
By default, a table column can hold NULL values.
SQL NOT NULL Constraint
The NOT NULL constraint enforces a column to NOT accept NULL values.
The 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.
The following SQL enforces the "P_Id" column and the "LastName" column to not accept NULL values:
Example
CREATE TABLE PersonsNotNull
(
P_Id int NOT NULL,
LastName varchar(255) NOT NULL,
FirstName varchar(255),
Address varchar(255),
City varchar(255)
)
(
P_Id int NOT NULL,
LastName varchar(255) NOT NULL,
FirstName varchar(255),
Address varchar(255),
City varchar(255)
)
Try it yourself »
'SQL' 카테고리의 다른 글
PRIMARY KEY Constraint (0) | 2015.06.11 |
---|---|
UNIQUE Constraint (0) | 2015.06.11 |
Constraints (0) | 2015.06.11 |
CREATE TABLE Statement (0) | 2015.06.11 |
CREATE DATABASE Statement (0) | 2015.06.11 |