Re: Changing a table name

Posted in 1996

Catalin Badea — 3 Dec 1996 18:37:28 GMT — source: Informix-list mailing list archive (1991-1998)

Peter Jennings <peter_jennings@uk.ibm.com> wrote in article <32A34319.662F@uk.ibm.com>... > Can anyone suggest a reason why we should not change > a table name by updating 'systables'? Provided that > ... > > Or is there a better way of doing it? > Why don't you use: rename table _oldTableName_ to _newTableName_ Catalin cat@tecsys.com P.S. Try to use DDL statements whenever possible.