How to add special constraints while creating table DDL

Question

I want to put some special constraints over my values in the next table:

CREATE TABLE MyTable
{
  id varchar(100) NOT NULL PRIMARY KEY,

  first_special varchar(8), <- I want it to have max of 8 symbols with no spaces in it

  second_special float  <- I want it to have precision of 2 decimal points after the '.'
}

EDIT:

The platform is Microsoft SQL Server.

Don't use float (or double or something similar). Those approximate types and what you store there is not necessarily the same that you retrieve later. Use numeric or number or whatever the name in your DBMS is. — user330315
– user330315, Commented Jul 10, 2014 at 17:19

drs · Accepted Answer · 2014-07-11 21:31:09Z

1

In Oracle (and I think in all dbs) the second one is easy.

second_special NUMBER(5,2) -- The max number would be 999.99

edited Jul 11, 2014 at 21:31

drs

5,8754 gold badges49 silver badges68 bronze badges

answered Jul 10, 2014 at 17:15

bowlturner

2,0264 gold badges26 silver badges38 bronze badges

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

Collectives™ on Stack Overflow

How to add special constraints while creating table DDL

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related