# Database objects

> For the complete documentation index, see [llms.txt](https://www.jetbrains.com/help/idea/2026.3/llms.txt).

Database objects

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

- [Database tool window](database-tool-window.html): A dedicated tool window to explore databases and manage database objects: overview and reference
- [Database diagrams](creating-diagrams.html): Create, analyze, and save diagrams of your databases and schemas

## Database objects

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

## Virtual objects

- [Virtual foreign keys](virtual-foreign-keys.html): Learn how to use virtual foreign keys
- [Virtual views](virtual-views.html): Create virtual views
- [Virtual columns](virtual-columns.html): Create virtual columns

## Source code and schemas

- [Modify source code of database objects](modifying-source-code-of-database-objects.html): Learn about loading, modifying and updating modified source code of database objects
- [Schema comparison and migration](schema-comparison-and-migration.html): Learn how to perform schema comparison and migration

## Data and code editors

- [Data editor and viewer](data-editor-and-viewer.html): Data editor and viewer
- [Query consoles](query-consoles.html): Query console

## Dialogs

- [Create and Modify dialogs](create-and-modify-dialogs.html): Create and Modify dialogs
- [Data Sources and Drivers dialog](data-sources-and-drivers-dialog.html): Data sources and drivers dialog