Microsoft KB Archive/161592

= BUG: CREATE TABLE Trailing Comma Not Treated as Syntax Error =

Article ID: 161592

Article Last Modified on 2/14/2005

-

APPLIES TO


 * Microsoft SQL Server 6.0 Standard Edition
 * Microsoft SQL Server 6.5 Standard Edition
 * Microsoft SQL Server 2000 Standard Edition

-



This article was previously published under Q161592



BUG #: 15676 (6.0) 16389 (6.5)      223765 (Shiloh_bug)



SYMPTOMS
If the column list in a CREATE TABLE command is terminated with a comma, as in the following statement:

create table CommaTab (cola int, colb char(8),)

SQL Server does not flag this as a syntax error.



WORKAROUND
To work around this problem, correct the CREATE TABLE command.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

Keywords: kbbug kbusage KB161592

-

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

© Microsoft Corporation. All rights reserved.