Hi , How can we add a column(s) dynamically to an existing table based on the date loading through a file?
For example, a table contains userid and phone number columns now. We get data on daily basis and load it into the table. on some day we get the additional column like Phone#2. We may get few more columns like home#, office#, Fax# .... but not sure how many extra columns we get in future. When we get an additional column in file, there should be an additional column created in table dynamically.
How can I achieve this?
Thanks.