Thank you very much. Le mardi 19 janvier 2021 à 14:34:58 UTC+1, Pylou Ej a écrit :
> I need to put a single value constraint on a column. So you advise me to > create an index and then assign it the unique constraint? > > > Le mardi 19 janvier 2021 à 13:53:34 UTC+1, Evgenij Ryazanov a écrit : > >> Hello. >> >> H2 preserves the specified name of constraint as is. Your command creates >> a constraint with the name GS_PAYS_UN1_1. This constraint in H2 needs a >> compatible index on column GS_PAYS_LIB. If such index wasn't found, H2 >> creates its automatically and name of such index is autogenerated. In your >> case in can be GS_PAYS_UN1_1_INDEX_3 or some else. >> >> It looks like you check the result in the wrong place. You can read >> constraints from INFORMATION_SCHEMA.TABLE_CONSTRAINTS table. >> > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/7fb10ed3-ee2e-44d4-b87f-2eec4aad00cdn%40googlegroups.com.
