Check if a column exists

#1

Hopefully a simple one, but I can't find anything obvious in the docs.

I want to add a column to my database only if it doesn't exist, as my
versioning scheme has gone a bit awry.

Can I put the statement in some sort of SQL try-catch, or is there an
easy way to check before adding?

Thanks

#2

On 22 Feb., 03:48, blackbird <adam.c.k... (AT) gmail (DOT) com> wrote:

Quote:

Hopefully a simple one, but I can't find anything obvious in the docs.

I want to add a column to my database only if it doesn't exist, as my
versioning scheme has gone a bit awry.

Can I put the statement in some sort of SQL try-catch, or is there an
easy way to check before adding?

Thanks

if not exists ( select 1
from sys.syscolumns
where creator = '__OWNER__'
and tname = '__TABLE__'
and cname = '__FIELD__'
) then

end if;
HTH

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Check if a column exists

sybase.public.sqlanywhere.general sybase.public.sqlanywhere.general

Check if a column exists - 02-21-2010 , 08:48 PM

Re: Check if a column exists - 02-22-2010 , 01:11 AM