CODEWITHSUNDEEP
sqlinformix
Erick Arturo Montes Torres
Erick Arturo Montes Torres

Reputation: 11

How to create CHECK constraints in Informix?

I need to create validations in my fields (columns) in Informix tables. Inside SQL Server, the names are CHECK (for example: CHECK (Age>=18))

How to create in Informix, or, what's the similar syntax in Informix?

Upvotes: 1

Views: 2111

Answers (1)

i.bondarenko
i.bondarenko

Reputation: 3572

If you want add check constraint you could do it in two ways:

1) The next example adds a new unit_price column to the items table and includes a check constraint to ensure that the entered value is greater than 0:

ALTER TABLE items 
   ADD (unit_price MONEY (6,2) CHECK (unit_price > 0));

2) To create a constraint that checks values in more than one column, use the ADD CONSTRAINT clause. The following example builds a constraint on the column that was added in the previous example. The check constraint now spans two columns in the table.

ALTER TABLE items ADD CONSTRAINT CHECK (unit_price < total_price);

Have a look at the doc

Upvotes: 1

Related Questions