Page 1 of 1

add a column

Posted: Sun Jan 26, 2014 5:52 pm
by navs1107
How to add a column if it is not there in a table.? means i want to check it first with the same column name if it is not there then add it else not.

Re: add a column

Posted: Sun Jan 26, 2014 9:48 pm
by JimKnicely
Hi,

Are you trying to do this from within vsql? If you issue the ALTER TABLE command and the column exists you'll just get an error that you can ignore, right?