BUG: CREATE TABLE Trailing Comma Not Treated as Syntax Error

ID: Q161592

The information in this article applies to:

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        :

Last Reviewed: April 7, 1999