Re: Null Table

david@cssnet.sanford.nc.us (J. David Schronce) writes: > WHile running checks against my Online 5.0 databases, I ran across > indexes attached to a table called "root". > > "root". seems to have no data associated to it. I've tried to drop it > without success. I can;t do a dbexport - it bombs when it hits the null > tablename, so I unloaded each table and generated a schema to rebuild the > correct tables. Unfortunately, I can't drop the database because of the > null table, to rebuild it. > > Is there any way I can drop this datbase without having to re-initialize > the entire dbspace? I have SEVERAL databases here and I dread the > thought of having to dbexport and rebuild ALL of them. > > I have no idea how this table got created, but certainly would love to > get rid of it. It's causing me all kinds of problems... > > Emailed replies will be summarized. And here they are! Special thanks to Brian Green for hauling my ample rump from the fire on this one! login as informix in ISQL; select tabname, tabid from systables order by tabname The null table will be first on the list Note the tabid delete from systables where tabid = (tabid from above) IT WORKS!!! Note: Children, do NOT try this at home. these people are trained professionals, working with MULTIPLE level 0 archives on hand. Modifying systables is not a good idea! ---dave---