How about:

lcDbName    = [Test]         &&& your DB Name
lcTableName = [Table_1]      &&& Table Name
lcFieldName = [ExistsThisField]   &&& adding column if not exists
TEXT TO lcSql NOSHOW TEXTMERGE PRETEXT 15
     IF  NOT EXISTS(SELECT * FROM <<m.lcDbName >>.INFORMATION_SCHEMA.COLUMNS
                             WHERE table_name = '<<m.lcTableName>>' AND column_name = '<<m.lcFieldName>>')
         ALTER TABLE <<m.lcDbName >>.dbo.<<m.lcTableName>> ADD <<m.lcFieldName>> numeric(12, 2) NULL
ENDTEXT

lnResult = SQLEXEC(m.sqlhandler,m.lcSql)
IF m.lnResult < 0
   AERROR(err_array)
   MESSAGEBOX(err_array(1,2))
   * Process this error
ENDIF

>Hi all
>
>May I know how we can check a MSSQL table structure and modify the structure by adding a coulmn of a MSSQL table programmaticaly from a VFP app?
>
>Your advice much appreciated.
>
>Thankas and Best Regards