• This is the situation

    I need to create tables dynamically on run time the schema of the table will be given by customer and same time he will give the data to insert.

    Needs to fetch data from newly created table with some master table on run time, need a join query on run time and fetch the data ,which will be used for update as well as select/delete.

    master_table1:20 columns

    master_table2:10 columns

    cust1:100 columns

    cust2:120 columns

    .

    .

    .

    Need to generate dynamic query on run time say for cust1 with master_table1 and master_table2 which has common id's in all the three tables, all this will be happen at run time.

    Dynamic insert also needs to takes place after table is been created i.e after the new table has been created the data for that table will be populated accordingly.

    Thanks!