SQL Server 2019 ProgrammingError: Incorrect syntax near 'AUTO_INCREMENT'

Question

Closed. This question is not reproducible or was caused by typos. It is not currently accepting answers. question from:https://stackoverflow.com/questions/65646108/sql-server-2019-programmingerror-incorrect-syntax-near-auto-increment

Answer 1

SQL Server doesn't support auto-increment. Nor does SQL Server -- or any other database -- support single quotes for column names (as far as I know).

I would recommend writing the statement as:

CREATE TABLE sqlalchemy_generic_types (
    sqlalchemy_generic_type_id INT IDENTITY(1, 1) PRIMARY KEY,
    ObjectName VARCHAR(25) NOT NULL,
    Description VARCHAR(100) NOT NULL
);

Note the changes:

• IDENTITY() is assigns an increasing value to the id.
• The id is given a meaningful name.
• The space is removed from ObjectName, so the name does not need to be escaped.
• No escape characters are needed to define the table.