Re: Trouble dropping tables

In article <3v89r8$fjd@cssun.mathcs.emory.edu> Mark.Denham@bbc.co.uk (Mark Denham) writes: > >Kate wrote: > >>I have a database that I can't save the structure of (with dbschema) as >>there's a weird table in it and dbschema falls over when it comes to it. >>I can't drop it as it says it doesn't exist. I can't modify it as it says >>its not there. Yet it appears in systables. I can't delete from systables >>where tabname = table's name as it says no permission. How can I get rid >>of it? > >Try deleting the row as user informix. You should also ensure that you get >rid of any entries in sysindexes and syscolumns etc that relate to this >table if you are going to do this. I personally do not advocate it unless it >is your only hope. > >You have not mentioned whether the db is SE/Online. > It's a SE db. And i tried logging on as Informix but got access denied to the db!