In SQL Server, it’s not a separate datatype (“autoincrement”) – but you can define an
How are you creating your table – visual designer or T-SQL script??
In T-SQL, you would use:
and in the visual table designer, you need to check:
It’s an option for a column of type INT – you can define the seed (starting value) and the increment – typically both are set to 1.