Answered

SQL Server IDENTITY

1 year ago • updated by 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,
);

Vote

Replies 1
Oldest first
- Newest first
- Oldest first

Answered

1 year ago

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!

Customer support service by UserEcho