SQL CREATE statement with a constraint

Question

I was wondering how to put a constraint on a column when making the table. How would the create statement look if I want to say something like, make a table called name with column size, and size has to be greater than 10.

CREATE TABLE name(size int);

Where do i put the constraint?

@poncha What's the syntax error in the CREATE TABLE statement? — shree.pat18
– shree.pat18, Commented Mar 12, 2014 at 14:42
by just doing "google" you should have find an answer or at least some direction if you are new to SQL. — Anup Shah
– Anup Shah, Commented Mar 12, 2014 at 14:46

shree.pat18 · Accepted Answer · 2014-03-12 14:39:19Z

3

You can include a constraint in your declaration right after you have specified the column name, like so:

CREATE TABLE name(size int CHECK (size > 10));

answered Mar 12, 2014 at 14:39

shree.pat18

21.8k3 gold badges45 silver badges65 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Rich Over a year ago

OP asked for a string check, not an integer check.

shree.pat18 Over a year ago

"make a table called name with column size, and size has to be greater than 10." is what OP said. Not exactly clear if he means the column called 'size' or size of the string

Rich · Accepted Answer · 2014-03-12 14:45:10Z

1

To create a minimum size, you would use the check (link) constraint. Additionally, you would have to use the len() method to verify a string is long enough.

Example:

CREATE TABLE Persons
(
P_Id int NOT NULL,
Name varchar(255) CHECK (len(Name) >= 10),
Address varchar(255),
City varchar(255)
)

answered Mar 12, 2014 at 14:45

Rich

4,1503 gold badges30 silver badges46 bronze badges

Comments

Ben Thul · Accepted Answer · 2014-03-12 17:24:07Z

1

Just because I've encountered more headaches than is necessary with system-named constraints, here's how to do it and also name the constraint in the process:

create table Persons (
   size int,
   constraint [CK_Persons_Size] check ((size > 10))
)

answered Mar 12, 2014 at 17:24

Ben Thul

32.9k4 gold badges52 silver badges74 bronze badges

Collectives™ on Stack Overflow

SQL CREATE statement with a constraint

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related