Re: Constraint Names

Posted in 1999

Obnoxio The Clown — Tue, 06 Apr 1999 10:17:10 GMT — source: Informix-list mailing list archive (1991-1998)

> 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? You can't (TTBOMK) rename it. But try: ALTER TABLE my_tableADD CONSTRAINT CHECK (my_field1 >= 1900) CONSTRAINT my_date_check; to call your constraint "my_date_check". HTH. -- "I'll Be Back" Obnoxio ************************************************ Sane? Hell, if I was sane, why would I be here? Get Your Private, Free Email at http://www.hotmail.com