5.1. NOT NULL
- The NOT NULL constraint enforces a column to NOT accept NULL values. This enforces a field to always contain a value, which means that you cannot insert a new record, or update a record without adding a value to this field.
QUERY :- create table c_Product (c_id int references company(c_id), c_product nvarchar(50), product_price int not null);
- SQL NOT NULL on ALTER TABLE :- To create a NOT NULL constraint on the column,
QUERY :- ALTER TABLE Table_Name
ALTER COLUMN Column_Name Datatype NOT NULL
EXAMPLE: - ALTER TABLE employee ALTER COLUMN e_id int NOT NULL, F_name nvarchar(50);
Last modified: Monday, 2 December 2019, 12:17 PM