Schema designer

The Schema Designer in the MSSQL extension for Visual Studio Code provides a graphical

environment for visualizing, designing, and managing database schemas without writing

Transact-SQL (T-SQL) statements.

Schema designer offers these features:

Visualize database structure with interactive diagrams.

Create or edit tables, foreign keys, primary keys, and constraints.

Search, drag and drop, filter, zoom, use a mini-map, and autoarrange diagrams for

efficient navigation and customization.

Export schema diagrams for documentation or sharing.

Automatically generate and view read-only T-SQL scripts representing your schema

changes.

Review and apply changes to the database with the Publish Changes feature.

Right-click on the database in the object explorer and select

from the menu.

This action opens the schema designer view, which then allows you to see the visual database

