BUG: CREATE TABLE Trailing Comma Not Treated as Syntax Error (161592)

The information in this article applies to:

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.

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

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

Modification Type:	Minor	Last Reviewed:	2/14/2005
Keywords:	kbBug kbusage KB161592