dynamic table creation with set of columns

  • Hi ,

    I have a list of records that are actually list of columns and table name that are coming from raw file and I need to create tables
    on the fly and add 200 columns in each table and table name should be like that is coming in the file but we need to split tables in multiple tables
    with some addition in the name like table_1,table_2 when the list of column exceeds the count of 200 that is our threshold.

    please suggest.

  • To be honest, that's not really enough information to base any useful advice on.   There's a lot more to take into consideration, and on a volunteer basis and for free, what you probably need may well be beyond the scope of what a free forum could reasonably provide.    Just the idea of having 200 columns isn't a particularly good idea most of the time.   We may be able to provide some guidance if you can provide more of the why's and wherefore's.   What's the scope of the objective?   Why do you need so many columns, and why is 200 the chosen limit?   What kind of data are we talking about?

    Steve (aka sgmunson) 🙂 🙂 🙂
    Rent Servers for Income (picks and shovels strategy)

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply