Re. Error during dropping database

Ronald Lim wrote }>Hi, }> }>I need help! }> }>When I try to drop a database, I encountered an error 214. }>The error message mentioned something about can't find table in }>syscolumns. I also try dropping all the tables from this database and }>then do a drop database. Still it didn't work. I am using informix 5.x. }> }>regards, }>Ronald Lim It seems as if you have lost a fil in the database dir. Make a select * from systables and check the files in your database dir with the output from the select. If we are talking Informix 5.x SE you can use the rm -r command from the unix prompt. Then the database is gone. If it is a Informix 5.x OnLine I am not sure how Informix is controling it databases. Bjarne W. Jensen /Alm. Brand Denmark