Re: delete table

The case of table that cannot be drop: *** WARNING THIS PROCEDURE IS THE LAST RESORT ******** 1) Logged in as informix or the owner of the database 2) Get the tabid of the table that is to be dropped. 3) delete these tabid in the system tables using query language. ex. the tabid of the table that cannot be drop is 258. run the sql in dbaccess. delete from systables where tabid = 258; delete from syscolumns where tabid = 258; delete from sysindexes where tabid = 258; delete from systabauth where tabid = 258; delete from syscolauth where tabid = 258; delete from sysviews where tabid = 258; delete from syssynonyms where tabid = 258; delete from syssyntable where tabid = 258; delete from sysconstraints where tabid = 258; delete from sysdefaults where tabid = 258; delete from syscoldepend where tabid = 258; delete from sysblobs where tabid = 258; delete from sysopclstr where tabid = 258; delete from systriggers where tabid = 258; delete from sysdistrib where tabid = 258; delete from sysfragments where tabid = 258; YOU MUST BE LOGGED IN AS "informix" . **** INFORMIX- The best RDBMS