Tables

Reference documentation for each Table item in the Solution Explorer

Overview

In Servoy, a table refers to a datasource identifier for tabular data, usually a table from a database. Tables are linked to dataproviders, used in filters, and interacted with through FoundSets in Servoy applications.

Commands Summary

A summary of commands available on this item via right-click context menu:

Command	Summary
Edit table/view	Opens the Table Editor
Open SQL Editor	Opens the SQL Editor
Copy Table	Duplicates the table
Hide in Developer	Flags the table as hidden in Servoy Developer
Synchronize with DB Server Information	Opens the Database Synchronization Wizard
Update Metadata	Opens the Metadata Synchronization Wizard
Delete Table	Deletes the table

Commands Details

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

Edit table/view

Opens the Table Editor to edit the table and its associated column information (metadata stored by Servoy Developer).

Open SQL Editor

Opens SQL Editor where you can run SQL queries on the table. SQL Explorer Eclipse plugin needs to be installed in order for this option to show up.

Copy Table

Creates a new table with exact same structure as the original (selected) one. You can choose a new name and the server where it should be created.

Hide in Developer

Mark a table as hidden in developer. This table (and its datasource) will not show up in Servoy Developer wizards and editors.

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.

Delete Table

Deletes the selected table after prompting a confirmation window.