Re: Tables in a database

Mark Fisher <fisherm@britannic.co.uk> wrote: :Is it possible to have 2 tables of the same name but owned by :2 different users on 1 database? : :e.g. "fred".table1 & "jane".table1 both on db1 : :I tried it, and got an error, but wanted to make sure I was :doing it "right". You can in a mode ansi database, but not in a regular Informix one. I wouldn't ever set up a database as mode ansi. The problems are to many. Most of the time when you have a problem like this you should either be able to solve it via temporary tables (where each session can have one of the same name) or some other simple construct. Sometimes an extra column with the username in a common table may be appropriate. If you post something about what you intend to achieve someone might give you more ideas. Nils.Myklebust@idg.no NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway My opinions are those of my company The Informix FAQ is at http://www.iiug.org