Re: Index Creation Questions

Posted in 1998

Eric Weaver — Mon, 24 Aug 1998 10:11:28 -0500 — source: Informix-list mailing list archive (1991-1998)

The IDS/UDO (Universal Server) manuals are misleading (Like our President, they are legally correct but do not volunteer information). You CAN alter a table in an inheritence structure (which must be a typed table). I've successfully altered typed tables to add unique, primary, and foreign key constraints. You cannot alter the structure (add columns, modufy data types) of a typed table however. Eric Weaver, InteliHealth Rico Jansen wrote: > > On Thu, 13 Aug 1998 16:57:26 +0300 (EETDST), > Octav Chiriac <com@netinfo.moldova.net> wrote: > >> > >>All constraints are created using ALTER TABLE statements AFTER the data > >>is loaded into the table. > > Does the restriction (on 9.* servers) hold that you cannot alter inherited > tables ? If that is you have no other option but to create the constraints > on creation of the tables. > > -- > Rico Jansen (rico@vpro.nl) > http://james.vpro.nl/ James a Webserver in Java. > "You call it untidy, I call it LRU ordered" -- Daniel Barlow