Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Old Forums
 CLOSED - General SQL Server
 Existence for particular column in a table

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2003-05-22 : 08:06:19
Nikhil writes "I want to check the existence of a particular column in a table. Because i want to add a new column in a table but before that i just want to check that column."

Page47
Master Smack Fu Yak Hacker

2878 Posts

Posted - 2003-05-22 : 08:07:29
Query syscolumns.

EDIT: or INFORMATION_SCHEMA.COLUMNS

Jay White
{0}

Edited by - Page47 on 05/22/2003 08:08:19
Go to Top of Page
   

- Advertisement -