Microsoft KB Archive/196768

= BUG: Table Designer Tool Does Not Allow Apostrophe in Column Name =

Article ID: 196768

Article Last Modified on 10/15/2002

-

APPLIES TO


 * Microsoft SQL Server 7.0 Standard Edition

-



This article was previously published under Q196768



BUG #: 50881 (SQLBUG_70)



SYMPTOMS
In Microsoft SQL Server, you can use SQL statements to create a table in which a column name contains an apostrophe. However, when you attempt to edit the table with the Table Designer tool, changes are not saved and you may receive the following error message:

Unable to modify table.

ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]Line 2:

Incorrect syntax near 's'.

[Microsoft][ODBC SQL Server Driver][SQL Server]Unclosed quotation mark

before the character string ')'.

If you use the Table Designer tool to create the table, the tool does not allow you to use an apostrophe in column names.



WORKAROUND
If you want to use the Table Designer tool to edit the table design, do not use apostrophes in your column names.



STATUS
Microsoft has confirmed this to be a problem in SQL Server version 7.0.

Additional query words: prodsql

Keywords: kbbug kbpending KB196768

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.