>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