Changing systables.owner
Posted in 1995
Timothy W. Moore — — source: Informix-list mailing list archive (1991-1998)
Has anyone ever changed the value in the owner field of systables? My company has different financial applications that share the same database. We want to write a 4GL program to unload only the tables for a certain application. The program is to dynamically get the table names from systables. We are planning to put a two letter abbreviation in the owner field to help us accomplish this. I have talked to Informix tech support and they said the only thing I have to be concerned about is to either create the tables with the new owner or export an existing database, edit the sql script to change the owner and import the database. Are there any problems to doing this? Thanks in advance.