Error modifying column properties.

Troubleshooting SQL Server

Troubleshooting

Error modifying column properties.

Appears when your constraint expression contains an error.

ODBC error text

[Microsoft][ODBC SQL Server Driver][SQL Server]The name '[column value]' is illegal in this context. Only constants, constant expressions, or variables allowed here. Column names are illegal.

Explanation

A default value defined for a character column is not enclosed in single quotation marks (').

Action

Enclose the value in single quotation marks in the database column's Default Value cell, and then save the table.

See Also

ALTER TABLE

Columns Property

Creating and Modifying DEFAULT Definitions

Modifying Column Properties