>>HI all
>>
>>My app is VFP9 running against MSSQL2005
>>
>>May I know how I can check if a field or stored proc exist in my MSSQL database.
>>
>>Your advice is much appreciated
>>
>>Thanks & Best Regards
>
>

>--- Check if the field exists
>
>IF EXISTS(SELECT * FROM INFORMATION_SCHEMA.COLUMNS 
>                   WHERE Column_Name = 'NameOfTheField' 
>                     AND Table_Name = 'YourTable')
>   SELECT CAST(1 AS bit) AS Exists
>ELSE
>   SELECT CAST(0 AS bit) AS Exists
>

>
>
>

>--- Check if SP exists
>
>IF EXISTS(SELECT * FROM sysobjects
>                   WHERE Name = 'YourSPName' 
>                     AND xType = 'P'
>   SELECT CAST(1 AS bit) AS Exists
>ELSE
>   SELECT CAST(0 AS bit) AS Exists
>

Hi Boris,

You can simplify this to the one SQL call, e.g.

select cast(case when exists(select 1 from ...) then 1 else 0 end as bit) as FieldExists