From help on drop table: Removes a table from the current database and deletes it from disk.

So in other words, if a table is in a database, you must use Drop table, if it's a "free table" you can just delete it.

>hi,
>thank you so much, it works.
>
>if you have a time what the different between delete and drop.in this case
>
>>>hi all,
>>>
>>>is there away to drop free table if found
>>>as
>>>

>>>locate for aa.dbf
>>> if found()
>>>   drop table aa
>>>else
>>>  mesagebox("not found")
>>>endif
>>>

>>>thanks
>>
>>

>>m.PathToFile = "c:\yourdir\"
>>lcSearchFile = m.PathToFile+"aa.dbf" &&& example lcSearchFile = c:\yourdir\aa.dbf
>>IF FILE(m.lcSearchFile)
>>   DELETE FILE(m.lcSearchFile)
>>ELSE
>>   MESSAGEBOX("Not Found")
>>ENDIF
>>