Re: [db_fan] Perl DBI: store the ddl of a column in a variable
[In reply to]

Can't Post

Hi,

DBI has a column_info method, as well as similar methods for fetching other schema level data. Of course you can also select this information from the ddl's internal views yourself, the relevant DBD module source should provide useful statements.

Re: [Zhris] Perl DBI: store the ddl of a column in a variable
[In reply to]

Can't Post

Thank you Chris. What if I have a number of columns? in Perl DBI, I need to create a temp table of those columns and generate a ddl of the temp table on Database A. Then, the DDL of the temp table will be loaded on database B. Do you have any hints on how to do that?