Hi, I think you are right, the syntax doesn't work as documented. I'm afraid we will have to either (a) implement it, or (b) change the documentation. Currently I think (b) is OK.
What you could do is create a constraint. The result is not different than if you would use "unique" when creating the table: the following two cases return the same script. drop table test; create table test(id int, name varchar unique); script nodata nosettings; drop table test; create table test(id int); alter table test add column name varchar; alter table test add constraint constraint_2 unique(name); script nodata nosettings; Another approach is to create a unique index. Regards, Thomas -- 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.
