Re: Changing a table name

Posted in 1996

Mark D. Stock — Wed, 04 Dec 1996 11:38:22 +0200 — source: Informix-list mailing list archive (1991-1998)

Peter Jennings wrote: > > Can anyone suggest a reason why we should not change > a table name by updating 'systables'? Provided that > we take reasonable precautions (eg backup, exclude > all other users etc.) Yes I can. System tables can change, but the SQL commands are always forward-compatible (so far :-). > Or is there a better way of doing it? Yes there is. Try the SQL command: RENAME TABLE old_table_name TO new_table_name Hope that helps, -- Mark. +-------------------------------------------------------------------------+ |Mark D. Stock - The West Solutions Group http://www.west.co.za | | The Informix FAQ is at http://www.iiug.org | |mailto:marks@west.co.za +------------------------------------------------+ |Tel: +27 11 803 2151 |If it doesn't work... force it! | |Fax: +27 11 803 2189 |If it breaks... it needed replacing anyway! | |Cell: +27 83 250 2325 |Well, that's how I code anyway! | +------------------------+------------------------------------------------+