>>Leaving aside the fact, that whole complicated code is already written based on ALTER TABLE, how can I do this process for DBC's tables?
>
>How about using something similar to this:
>
>
>use MyTable
>copy structure to TempAlterTable
>alter table ...
>use MyTable
>zap
>append from TempAlterTable
>
>
>You would have to include a few more commands, of course; for instance, perhaps you might prefer to use sys(2015) instead of TempAlterTable.
>
>HTH, Hilmar.
Hilmar,
This is easy to write here, but it's really complicated to implement.
First of all, the code is already written and it's couple of complicated programs. I can send you them, if you like, so you'll see how complex they are.
Secondly, these tables are part of DBC, have field rule validations and captions and comments...
Finally, even the simple code you showed, contains couple of typos (errors). :)
If it's not broken, fix it until it is.
My Blog