AppCode 2019.1 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.

the Create schema dialog

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 .

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

  • 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.

    If needed, change the value of the Tolerance parameter in the comparison dialog. The Tolerance parameter defines a maximum number of differences that are allowed between two result sets. For example, if you want to consider two rows as equal if their data differs in a single column, enter 1 in the Tolerance field.

Compare two schemas
Last modified: 18 April 2019