Create Load Statement from SQL Schema Definition

[Anonymous]

I have a large number of tables that I want to generate  Load script for as opposed to manually writing the script for each table.  I have retrieved the table names and column names from SQL as illustrated below:

I would like to generate a script file that looks like:

AccountCombos:

   Load PK,

     ... REMAINING COLUMNS ...  ;

  SELECT SQL

     ...  COLUMN LIST ;

  From AccountCombos;

  Store AccountCombos into ../qvd/AccountCombox.qvd(qvd);

  drop table accountCombos;

[Gysbert_Wassenaar]

For SQL Server there's an extractor .qvw app available. It shouldn't be too hard to adapt it for other sql databases. Especially if you already have the schema data available.