MySQL server version for the right syntax to use near 'IDENTITY'

See more:

SQL

SQL-Server

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IDENTITY,

If i had to ques the problem seems to be with this line

Newt_Id INTEGER NOT NULL UNIQUE IDENTITY,

where "UNIQUE IDENTITY" phrase is not supported in MS SQL server 2008.

My question: Why is this problem occurring and how to fix it? + This SQL code is automatically generated by another program so would it be possible to simply use a different version of SQL server?

CREATE TABLE Person
(
  Newt_Id INTEGER NOT NULL UNIQUE IDENTITY,
  Newt_CreatedBy INTEGER NULL,
  Newt_CreatedDate DATETIME NULL,
  Newt_UpdatedBy INTEGER NULL,
  Newt_UpdatedDate DATETIME NULL,
  Newt_TimeStamp DATETIME NULL,
  Newt_Deleted INTEGER NULL,
  Newt_Secterr INTEGER NULL
)

Any comments or suggestion are welcome. Thank you.