SQL Server IDENTITY
kru1983 8 months ago • updated by hannah gryska 8 months ago • 1
Hi Team, Is there an option to add "IDENTITY" in my diagrams?
Here is an example where I want the column to auto increment.
CREATE TABLE flights ( id INT IDENTITY(1, 1) PRIMARY KEY, origin VARCHAR(255) NOT NULL, destination VARCHAR(255) NOT NULL, duration INTEGER NOT NULL, );
Customer support service by UserEcho
Hello, thank you for reaching out. If you click inside the column which you'd like to add IDENTITY to, in the Column Properties menu on the right-hand side, you can click Options, then check the Identity box, as shown in the screenshot. I hope that helps!