Is it correct that SQL Server does not support IDENTITY(slide 29)?<p>IDENTITY property is supported from as far as I can remember:
<a href="https://docs.microsoft.com/en-us/sql/t-sql/statements/create-table-transact-sql-identity-property?view=sql-server-2017" rel="nofollow">https://docs.microsoft.com/en-us/sql/t-sql/statements/create...</a><p>Second approach is DEFAULT with sequence.<p>CREATE SEQUENCE seq;
CREATE TABLE tab(i INT DEFAULT NEXT VALUE FOR seq, b VARCHAR(100))