>Another thought...
>
>Why do you bother with the COPY STRUCTURE EXTENDED step? You can cut straight to the chase and get a new table with no records:
>
>

>copy to (m.lcNewBldMstr+'_B') database (m.lcNewBldMstrName) for .f.

>
>

Will it preserve default values, rules, etc.? The original code was written by my colleague, I never really changed the algorithm except for minor enhancements...

>>Hi everybody,
>>
>>I think, I'm going crazy. Here is the code
>>

create (m.lcNewBldMstr+'_B') database (m.lcNewBldMstrName) from (m.ltBldMstr)

>>
>>ltBldMstr is a temp table (created by copy structure extended command)
>>
>>I was stepping through this code in debugger and this line was executed. So, in my opinion, the new blank table should be created. However, the table is full of records, which are leftover from the previous run. I ran this code several times and always table contained records. What could be wrong here?
>>
>>Of course, I can delete the whole database and recreate this table in a code, but why this line doesn't do, what I'm thinking, it should do?
>>
>>Thanks in advance for saving me from insanity...