Is there a way to check for the existence of a column in a table otherthan, say, doing a SELECT on that column name and checking the output?
I'm basically looking to do an ALTER TABLE foo ADD COLUMN bar if bardoesn't exist.
Thanks.
-- Brandon