Database - SQL for Database Construction - Discussion
Discussion Forum : SQL for Database Construction - General Questions (Q.No. 16)
16.
What SQL structure is used to limit column values of a table?
Discussion:
5 comments Page 1 of 1.
Namit Singh said:
7 years ago
How option B is the correct answer?
According to me, the limit is the right answer.
According to me, the limit is the right answer.
Junaid M said:
8 years ago
The CHECK constraint is used to limit the value range that can be placed in a column.
CREATE TABLE Persons (
ID int NOT NULL,
LastName varchar(255) NOT NULL,
FirstName varchar(255),
Age int,
CHECK (Age>=18)
);
CREATE TABLE Persons (
ID int NOT NULL,
LastName varchar(255) NOT NULL,
FirstName varchar(255),
Age int,
CHECK (Age>=18)
);
(1)
SWETA SAPNA said:
9 years ago
Please explain more about check constraint.
Sdf said:
1 decade ago
How? Please it can be describe.
Sandip said:
1 decade ago
only check constraint is used for make a boundaries between table column.
Post your comments here:
Quick links
Quantitative Aptitude
Verbal (English)
Reasoning
Programming
Interview
Placement Papers