Table structure updates with CdbObjects
Posted on 1998-05-13
I am trying to build a database dynamically using the
CdbDatabase family of objects. What I need to do is given
a list of tables and fields, I need to construct the
new tables. The way I do it is I create the table with
the one field I know will be there, append it, and come
back to it later. When I do, I am supposed to check to
see if the field exists in the table, and if not, add
the field to the table. I can, it would seem, determine
if the field exists in the table, but can't add it to
the table, since all I can find for CdbTableDef is the
Create method, and not an Update or anything like it.
Any help would be appreciated.