DataGrip 2019.2 Help

Schemas

Create a schema

  1. Click the data source in which you want to create a schema.

  2. Navigate to File | New | Schema.

  3. In the Name field, specify a name of the schema.

  4. Click Execute.

Select the default schema

You can select the default schema or database by using the list in the right-hand part of the toolbar. If you do so, you'll be able to omit the name of that schema or database in your statements.

Click the <session> list and select the schema that you need.

Select the default schema or database

Show and hide schemas

You can select what schemas you want to show in the database tree view.

  • In the Database tool window (View | Tool Windows | Database), right-click a data source and navigate to Database Tools | Manage Shown Schemas. Select or clear checkboxes of schemas that you want to enable or disable. Press N/A.

  • Click the N connections link near the data source name. Select or clear checkboxes of schemas that you want to enable or disable. Press N/A.

  • To hide all schemas, navigate to Database Tools | Hide Schemas.

Show and hide schemas

Compare two schemas

  1. Select two schemas.

  2. Right-click the selection and navigate to Compare.

Compare two schemas

Set the schema search path for PostgreSQL and Redshift

The search_path environment variable in PostgreSQL specifies the order in which schemas are searched. For example, you set the value of search_path to z,a,public, PostgreSQL will look for a value in the z schema. If nothing was not found in the z schema, PostgreSQL looks for the value in the a schema.

In PostgreSQL and Amazon Redshift, the default search path (the path that is set in a database) is used unless you specify a different search path.

  1. Click the <session> list, navigate to the list of database schemas (use the arrow icon the Arrow icon or press the right arrow key).

  2. Select the schema that you want to add to a search path.

    To form a search path, you can use the following actions:

    • Press N/A to add a highlighted schema to the search path and to remove a schema from the search path.

    • Press N/A and N/A to reorder the schemas within the search path.

  3. To apply the changes, press OK.

Control the search path for PostgreSQL and Redshift

Force refresh schema information

The Force Refresh action clears the data source information from cache and loads it again from scratch.

In the Database tool window (View | Tool Windows | Database), right-click a data source and select Database Tools | Force Refresh.

Force refresh schema information

Show objects from system catalogs in coding assistance

A system catalog is the place where a relational database management system (DBMS) stores information about tables and columns, built-in functions, and other schema objects. These objects are used in coding assistance (for example, code completion).

System schemas have the lightning icon icons actions lightning svg in the schema selection dialog. If you do not select these schemas, DataGrip will not introspect them and will not show them in the Database tool window. Though information about schema objects will be used in coding assistance. It is possible because DataGrip uses internal data about schema objects that was introspected earlier.

Examples of system catalogs in different DBMS:

  • PostgreSQL: pg_catalog, information_schema

  • Microsoft SQL Server: INFORMATION_SCHEMA

  • Oracle: SYS, SYSTEM

  • MySQL: information_schema

  • IBM Db2: SYSCAT, SYSFUN, SYSIBM, SYSIBMADM, SYSPROC, SYSPUBLIC, SYSSTAT, SYSTOOLS

Show objects from system catalogs in coding assistance
    Last modified: 19 August 2019