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"
>>IF FILE(m.lcSearchFile)
>> DELETE FILE(m.lcSearchFile)
>>ELSE
>> MESSAGEBOX("Not Found")
>>ENDIF
>>