SQL Server Developer >> check if field exist
IF EXISTS (SELECT 1
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME='your_table_name'
AND COLUMN_NAME='your_column_name')
PRINT 'column exists.'
ELSE
PRINT 'column does not exist.'
> hi all
> how can check if the field 'mycol' if exist in table or not programing ?
>
> Tankes
>
>
>
>
>