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
 SQL Server 2000 Forums
 Transact-SQL (2000)
 cek if field name exists

Author  Topic 

djokerss
Starting Member

28 Posts

Posted - 2005-01-07 : 21:33:01

i'like to make change with my table with add a new column,
how to check if the column is exist or not,while not exist
column will added

Stoad
Freaky Yak Linguist

1983 Posts

Posted - 2005-01-08 : 00:30:55
if col_length('t', 'col_name') is null
<do this>
else
<do that>
Go to Top of Page

djokerss
Starting Member

28 Posts

Posted - 2005-01-08 : 00:39:26
thanks....that all i need...
Go to Top of Page
   

- Advertisement -