Re: comp.databases.informix

Stephen C. Dickey (scdickey@wdrake.com) wrote: : How do I change the owner of existing Informix tables? Apparently the RENAME : TABLE command will not work for this. The "official" way would be to generate a table creation script with dbschema, edit the script, unload the data, drop the table and reload the data. If there are no constraints to worry about, you could onunload, DROP and onload (but I don't think this would maintain index names). The "unofficial" way would be to amend the system catalogs (and the filesystem if you're running SE). If you need more detail about the latter approach, then stick to the former approach. If you don't think you need more detail, then don't forget non-table objects and consider authorities! -- graeme -- Disclaimer: The author's opinions are his own, and not necessarily those of Pyramid Technology Ltd. or Pyramid Technology Inc. --------------------------------------------------------------------------- -m------- Graeme Sargent Voice: +44 (0)252 373035 ---mmm----- Senior Database Consultant Fax : +44 (0)252 373135 -----mmmmm--- Pyramid Technology Ltd. Telex: Tell who??? -------mmmmmmm- Farnborough, Hants GU14 7PL Email: graeme@pyra.co.uk --------------------------------------------------------------------------- We have the technology. The tricky bit is learning how to use it.