Trouble dropping tables

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. Mark Denham BBC London, UK Mark.Denham@bbc.co.uk