ALTER Table ....

[Göran Pettersson]

Hi all.

I have a problem, and wonder if anybody can give me a tip how to solve it.

It's so, that I from time to time need to add extra column(s) into my DB. This can I do with the ALTER command, no problem.

But I would like to put in a check to see if the column already exist before I try to add it. Today I do this check in my client program, but it would be must smarter and simpler if i could do this test in the SQL statement direct.

If this is possible to solve with one column, is it then also possible to do this check if I would like to add more than one column in the same statement ??

Thank for Your comments ...

Göran P.