>Hi Borislav,
>
>I tried to execute the sample that you gave in Query Analyzer and it gave an error message:
>
>Server: Msg 156, Level 15, State 1, Line 1
>Incorrect syntax near the keyword 'DEFAULT'.
>
>any idea?
Mike,
Because you post your question in VFP forum I decide you want the VFP syntax :-)
Here for SQL Server:
ALTER TABLE Customer ADD CONSTRAINT [DF_Customer_Flag] DEFAULT (1) FOR [flag]
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.