Database objects
Learn how to work with database objects and their settings in Database Explorer and data editor. How to modify, copy, import the objects, compare them and see the differences.
| Schemas | Learn how to 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 views. |