Those are table constraints.
For column constraints, do this:

select * from information_schema.columns
WHERE TABLE_NAME = 'CHECK_TEST'

On 2012-02-27 01:33, Shammat wrote:
CREATE TABLE check_test
(
   id           INTEGER NOT NULL PRIMARY KEY,
   some_value   INTEGER NOT NULL CHECK (some_value>  0)
);

--
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to 
[email protected].
For more options, visit this group at 
http://groups.google.com/group/h2-database?hl=en.

Reply via email to