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
Commands Summary
The following commands are available for any Database Server nodes. They can be accessed by right-clicking the context menu.
Commands Details
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
Last updated