Knowledge Base

BUG: CREATE TABLE Trailing Comma Not Treated as Syntax Error

Article ID: 161592

Article Last Modified on 2/14/2005

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