Re: Trouble in dropping a table: not there but appears in systables

you could try copying a .dat .idx pair to the name of the table you're trying to get rid of then dropping it. EG You're trying to get of "mytab". From systables you know the file is called "mytab123". type: cp systables.dat mytab123.dat cp systables.idx mytab123.idx Then in ISQL run: drop table mytab ------------------------------------------------------------------- These are *my* opinions. Please don't make the mistake of believing anybody else is stupid enough to think like this! ------------------------------------------------------------------- Stuart Hemming | shemminga@cix.compulink.co.uk The Data Base | Tel: + 44 (0) 115 925 0005 Nottingham UK | Fax: + 44 (0) 115 925 0951 -------------------------------------------------------------------