0
Answered

SQL Server IDENTITY

kru1983 1 year ago updated by hannah gryska 1 year 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,
);
Answered

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!