Hi ! I cannot figure out how I can add an unique column using H2. According to documentation, this should work: alter table testit add myuniquecol varchar(50) unique; But I keep on getting error: [Error Code: 42000, SQL State: 42000] Syntax error in SQL statement "ALTER TABLE TESTIT ADD MYUNIQUECOL VARCHAR(50) UNIQUE[*] "; SQL statement: alter table testit add myuniquecol varchar(50) unique [42000-166]
Creating a table with similar syntax is working fine: create table testit (id bigint primary key, uni varchar(50) unique); Can anyone help me on the correct syntax to use (or is this a bug ?) ? Thanks ! PS. I don't want to use separate add constraint, because my sql is generated by liquibase -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To view this discussion on the web visit https://groups.google.com/d/msg/h2-database/-/0ZdknA0PALgJ. 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.
