Thanks for the answer. Actually it seems that when using
alter table check_test add constraint positive_value CHECK (some_value > 0) that will be recorded in information_schema.constraints whereas an "inline" check constraint will be recorded in information_schema.columns Is this intended? On 27 Feb., 12:16, Noel Grandin <[email protected]> wrote: > 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.
