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 Default Object
Columns Property Expressions
Constraints How to set column properties using a database diagram (Enterprise Manager)
CREATE TABLE Modifying Column Properties
Creating and Modifying DEFAULT Definitions  

 

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.