Database Server

Reference documentation for individual Database Server nodes

Overview

There will be one Database Server node in the Solution Explorer for each connection that you have configured. Expanding this node will show a list of all tables (they are also displayed in the contextual list), procedures and views.

Commands Summary

The following commands are available for any Database Server nodes. They can be accessed by right-clicking the context menu:

Command	Summary
Open Server	Opens the DB Server connection in the Database Connection Editor.
Create Table	Creates a new table in the target database and opens the Table Editor
Duplicate Server	Creates a new DB Server connection with identical connection properties and opens it in the Database Connection Editor
Enable/Disable Server	Toggles the enabled property of DB Server
Synchronize with DB Server Information	Opens the Database Synchronization Wizard
Update Metadata	Opens the Metadata Synchronization Wizard
Reload Tables/Structure from DB	Reloads the schema from the database
Load Relations	Can create relations based on database tables FOREIGN KEY constraints.
Flag Tenant Columns	Specifies the column name which can be used as a tenant filter for all tables
Suggest Foreign Types	Sets foreign types to columns
Delete Database Connection	Deletes this DB Server connection

Commands Details

The details for each command available on this item via right-click context menu:

Open Server

Opens the DB Server connection in the Database Connection Editor.

Create Table

Creates a new table in the target database and opens the Table Editor.

Duplicate Server

Creates a new DB Server connection with identical connection properties and opens it in the Database Connection Editor

Enable/Disable Server

Toggles the enabled property of DB Server.

Synchronize with DB Server Information

Use this command to synchronize between the database schema and the Database Information (.dbi) files in your project. This command will open the database synchronization wizard, where you can resolve differences between the schema and your .dbi files.

Update Metadata

Opens a wizard to synchronize the metadata tables content (which have special structure and are marked as such from table editor) and metadata tables workspace content.

Reload Tables/Structure from DB

Reloads tables from database. Should be used when tables are modified outside Servoy, in order to refresh them.

Load Relations

Opens a wizard for creating relations based on foreign key constraints from the database. Useful when having an existing database, in order to quickly create some relations.

Flag Tenant Columns

Sets a column name to be used as tenant column for all tables in selected database.

Suggest Foreign Types

Opens a wizard which can set Foreign Type on columns based on suggestion.

Delete Database Connection

Deletes the database connection (not the database itself). The database connection is stored under servoy.properties file