Re: Constraint Names
You can set the constraint name when you create it:
> alter table my_table
> add constraint check (my_field1 >= 1900 )
constraint check_constr1;
I don't now how you can change the name of constraint.
Best Regards,
Octav
On Tue, Apr 06, 1999 at 12:38:14PM +0300, Olcay Sarioglu wrote:
>
> How can I set a name for a new check constraint? For example
>
> alter table my_table
> add constraint check (my_field1 >= 1900 );>
> works fine but the resulting constraint name is not what I want. It is
> given by Informix. How can I rename it later?
>
> == Olcay Sarioglu
>
> Informix Dynamic Server Version 7.30.UC5
>
--
Octav Chiriac Phone: (373) 2 21 20 96
NetInfo S.R.L. Fax: (373) 2 21 36 59
Chisinau (373) 2 24 00 83
Moldova, Republic of mailto:com@netinfo-moldova.com