add a column
Moderator: NorbertKrupa
add a column
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.
-
JimKnicely
- Site Admin
- Posts: 1825
- Joined: Sat Jan 21, 2012 4:58 am
- Contact:
Re: add a column
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?
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?
Jim Knicely
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.