BUG: CREATE TABLE Trailing Comma Not Treated as Syntax Error

ID: Q161592

The information in this article applies to:

Microsoft SQL Server versions 6.0, 6.5


BUG #: 15676 (6.0)
       16389 (6.5)

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 this to be a problem in Microsoft SQL Server versions 6.0 and 6.5. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

Keywords : kbusage SSrvTran_SQL kbbug6.50 kbbug6.00
Version : 6.0 6.5
Platform : WINDOWS
Issue type :