Alter Table Constraint Not Null (what is exact method for this?)

[mflancour]

This is how I tried to write it, but error occures.

MyDB.Execute "ALTER TABLE month ADD CONSTRAINT stuff NOT NULL ([f1])"

 

[TonyJollans]

Hi mflancour,

I don't think you can alter it as a constraint.

The syntax, I think is ALTER TABLE TableName ALTER COLUMN ColumnName DataType NOT NULL

.. and it is not available prior to 2K.

I think you have to specify the data type even if you are not changing it.

Enjoy,
Tony

------------------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading FAQ222-2244 before you ask a question.