Free · No sign-up · Nothing installed

SQL Server to ER Diagram

Paste the script from SSMS's Generate Scripts wizard — [dbo] brackets, IDENTITY columns, GO batches and all. Schema only, no connection strings.

SQL input — CREATE TABLE · DDL · dumpsqlserver

CREATE TABLE [dbo].[users] (
  [id] INT IDENTITY(1,1) NOT NULL,
  [email] NVARCHAR(320) NOT NULL,
  [display_name] NVARCHAR(120) NULL,
  [created_at] DATETIME2(0) NOT NULL CONSTRAINT [df_users_created_at] DEFAULT (sysutcdatetime()),
  CONSTRAINT [pk_users] PRIMARY KEY CLUSTERED ([id] ASC)
);

CREATE TABLE [dbo].[posts] (
  [id] INT IDENTITY(1,1) NOT NULL,
  [author_id] INT NOT NULL,
  [title] NVARCHAR(200) NOT NULL,
  [body] NVARCHAR(MAX) NULL,
  [status] TINYINT NOT NULL CONSTRAINT [df_posts_status] DEFAULT ((0)),
  [published_at] DATETIME2(0) NULL,
  CONSTRAINT [pk_posts] PRIMARY KEY CLUSTERED ([id] ASC)
);

CREATE TABLE [dbo].[comments] (
  [id] INT IDENTITY(1,1) NOT NULL,
  [post_id] INT NOT NULL,
  [commenter_id] INT NOT NULL,
  [body] NVARCHAR(4000) NOT NULL,
  [created_at] DATETIME2(0) NOT NULL CONSTRAINT [df_comments_created_at] DEFAULT (sysutcdatetime()),
  CONSTRAINT [pk_comments] PRIMARY KEY CLUSTERED ([id] ASC)
);

CREATE TABLE [dbo].[tags] (
  [id] INT IDENTITY(1,1) NOT NULL,
  [slug] NVARCHAR(80) NOT NULL,
  CONSTRAINT [pk_tags] PRIMARY KEY CLUSTERED ([id] ASC),
  CONSTRAINT [uq_tags_slug] UNIQUE ([slug])
);

CREATE TABLE [dbo].[post_tags] (
  [post_id] INT NOT NULL,
  [tag_id] INT NOT NULL,
  CONSTRAINT [pk_post_tags] PRIMARY KEY CLUSTERED ([post_id] ASC, [tag_id] ASC)
);
GO

-- the way SSMS "Generate Scripts" writes foreign keys:
ALTER TABLE [dbo].[posts] WITH CHECK ADD CONSTRAINT [fk_posts_author] FOREIGN KEY([author_id]) REFERENCES [dbo].[users] ([id])
ALTER TABLE [dbo].[posts] CHECK CONSTRAINT [fk_posts_author]
GO
ALTER TABLE [dbo].[comments] WITH CHECK ADD CONSTRAINT [fk_comments_post] FOREIGN KEY([post_id]) REFERENCES [dbo].[posts] ([id]) ON DELETE CASCADE
ALTER TABLE [dbo].[comments] CHECK CONSTRAINT [fk_comments_post]
GO
ALTER TABLE [dbo].[comments] WITH NOCHECK ADD CONSTRAINT [fk_comments_commenter] FOREIGN KEY([commenter_id]) REFERENCES [dbo].[users] ([id])
ALTER TABLE [dbo].[comments] CHECK CONSTRAINT [fk_comments_commenter]
GO
ALTER TABLE [dbo].[post_tags] WITH CHECK ADD CONSTRAINT [fk_post_tags_post] FOREIGN KEY([post_id]) REFERENCES [dbo].[posts] ([id]) ON DELETE CASCADE
ALTER TABLE [dbo].[post_tags] WITH CHECK ADD CONSTRAINT [fk_post_tags_tag] FOREIGN KEY([tag_id]) REFERENCES [dbo].[tags] ([id]) ON DELETE CASCADE

sqlserverSample: · · · · ·

Diagram—

Your diagram renders here.

Parser coverage

What we parse in sqlserver

Bracketed identifiers — [dbo].[orders] unwrapped, dbo shown as a labeled group
IDENTITY(1,1) — folded into the PK column, DATETIME2(0) / NVARCHAR(MAX) verbatim
GO batch separators — split the way SSMS writes multi-batch scripts
Wizard foreign keys — WITH CHECK / WITH NOCHECK ALTER TABLE forms, ON DELETE kept

From your database

Get just the schema

SSMS → right-click database → Tasks → Generate Scripts → Advanced → "Types of data to script" = Schema only

Two clicks, and the .sql file it writes pastes cleanly above — no drivers, no credentials, nothing installed.

FAQ

Questions, answered

How do I generate an ER diagram from SQL Server?

In SSMS, right-click the database → Tasks → Generate Scripts, set "Types of data to script" to Schema only, then paste the .sql output above.

Does it handle GO separators and [dbo] brackets?

Yes — GO batches are split the way SSMS writes them, and bracketed names like [dbo].[sales_orders] are unwrapped automatically.

What about IDENTITY columns and defaults?

IDENTITY(1,1) is folded into the PK column; DEFAULT constraints and CHECK CONSTRAINT re-enable statements are treated as noise, not columns.

Does it connect to my SQL Server instance?

Never. You paste DDL text — nothing touches your server, and there is nothing to install.

More converters

SQL Server to ER Diagram

What we parse in sqlserver

Get just the schema

Questions, answered

Also available