Re: Want to Know Colunm exist or not

From: Hugo Kornelis (hugo_at_pe_NO_rFact.in_SPAM_fo)
Date: 05/12/04 

Date: Wed, 12 May 2004 10:48:57 +0200

On Tue, 11 May 2004 21:41:03 -0700, Ashish Patel wrote:

>Dear Friend,
>
>I want to know that particular colunm is exist in table or not..
>if not exist then i want to create it.
>
>regards ashish

Hi Ashish,

I would check the documentation for the table to see if the columns
exists. If it does, fine. If not, I'd add the column and update the
documentation.

If you have no documentation, use sp_help MyTable to see how it is
currently defined, then create the documentation (the sp_help output
may be a good starting point).

Best, Hugo 

-- 
(Remove _NO_ and _SPAM_ to get my e-mail address)

Relevant Pages