Skip to Content

Add Column to existing table

Hi All,

I would like to add a column to an existing table without the database.

Here my scenario is I have source having 25 columns at the same time my target having 24 columns, I have to add the new column in the target table. I do not have database access, my superior saying can do it through BODS designer. anybody help on this?



Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    Posted on Sep 13, 2016 at 02:50 PM

    Use a template table.

    All details are in section 2.3.28 of the SAP Data Services Reference Guide.

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi Ravi,

      The way you suggested might work, but I think it is not better approach what Bogdan suggest, why means, suppose in our job if we have lot of dataflows(for ex:10), for change target structure in one target table, we have to run whole job.

      another way is create a sample job and run the script only. but it will best when we are working development but in Production do we have any other alternative option?



Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.