Database objects

Explore your databases, work with database objects and diagrams, perform migrations

• Database tool window: A dedicated tool window to explore databases and manage database objects: overview and reference
• Database diagrams: Create, analyze, and save diagrams of your databases and schemas

Database objects

• Schemas: Display the schemas you need, select the default one, change the search path, and generate a diagram for your schema
• Tables: Work with tables, compare them, and view their data
• Views: Create and modify database views
• Columns: Add and modify columns, edit their database-specific parameters, inject a language, and more
• Primary keys: Create new primary keys and make columns a primary key
• Foreign keys: Create foreign keys, use virtual foreign keys, navigate between related rows, and more
• Indexes: Create and work with templates for generated indexes
• Users and roles: Create users and roles and configure privileges and permissions

Virtual objects

• Virtual foreign keys: Learn how to use virtual foreign keys
• Virtual views: Create virtual views
• Virtual columns: Create virtual columns

Source code and schemas

• Modify source code of database objects: Learn about loading, modifying and updating modified source code of database objects
• Schema comparison and migration: Learn how to perform schema comparison and migration

Data and code editors

• Data editor and viewer: Data editor and viewer
• Query consoles: Query console

Dialogs

• Create Table and Modify Table Dialogs: Create and Modify dialogs
• Data Sources and Drivers dialog: Data sources and drivers dialog