See INDBC() function. Then use REMOVE TABLE to remove the table from the DBC without deleting it from disk. DROP TABLE will delete it from disk.
>Hey, I am wanting to test for a table existing in a dbc. If it is already is there I want to remove it and replace it with a new table. What is the easiest command to do this with? I am not really worried about the replacement, just the testing for it to begin with.
>
>Thought about:
>
>llexists = !empty(dbgetprop(cdbfname,[table],[path]))
>
>But then I have to trap the error if it isn't there.
>
>----
>If I am going to do that I might as well do:
>
>remove table (cdbftable) recycle && or should I use delete?
>
>Then again I have to error trap in case it isn't already there.
>
>----
>Also thought about:
>
>copy stru exte to tempdbf
>sele 0
>use tempdbf
>loca for allt(field_name) = cdbfname
>llexist = found()
>
>But this seems cumbersome.
>
>In the back of my mind I have a feeling like there must be a nifty little command I am forgetting that would be simpler that any of these approaches.
Mark McCasland
Midlothian, TX USA