hello all,


What's the best way to deals with those constraint :

create domain Plantype as VARCHAR(20) not null;
create table typeP
(
Plantype Plantype
PRIMARY KEY check(typeAvion like '[A-Z]%'),

or something like :
IdAirport typeidairport PRIMARY KEY check (idairport like '[A-Z][A-Z]
[A-Z]')

Is it possible to precise the constraint in the domain ?

Thanks,

Akim