Add comment when migrating a table

Database

Add comment when migrating a table

I am in the process of developing a bteq script that captures ddl from dbc.tables for migration purposes.  I'm creating a series of 'show table' entries into a file that is then executed to create the ddl.  Does anyone know of a good way to also capture the table and column level comments to apply to a table when migrating from one environment to another?

Thanks,

Joe

1 REPLY
N/A

Re: Add comment when migrating a table

Did you consider to use arcmain to migrate DDL's?

Beside this dbc.tables and dbc.columns contain the commentstring. So you should be able to generate the comment statements as well.