Re: delete table

Lone Ranger (Silver@bullet.com) wrote: : *** WARNING THIS PROCEDURE IS THE LAST RESORT ******** : 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; you really don't want to do this, because the table will still be listed in the tblspace tblspace at the beginning of the dbspace, and this can cause all kinds of havoc. if it really is necessary to get rid of this table, then call informix support. they can dial in and take care of it within a few minutes. on the other hand, if the table isn't that big, or if you can delete all the rows from it, (i forget if you can access it at all or not), then you could just leave it around. it won't hurt anything, (execpt it's annoying presence)... hope that helps. mickm -- _____________________________________________________________________________ Mickey Mestel mickm@ix.netcom.com Note the address change - it's now ix.netcom.com. My original identity remains intact however. (whew!) -----------------------------------------------------------------------------