# Tables

## 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](#edit-table-view)                                               | Opens the [Table Editor](https://docs.servoy.com/reference/servoy-developer/object-editors/table-editor)                                       |
| [Open SQL Editor](#open-sql-editor)                                               | Opens the [SQL Editor](https://docs.servoy.com/reference/servoy-developer/object-editors/sql-editor)                                           |
| [Copy Table](#copy-table)                                                         | Duplicates the table                                                                                                                           |
| [Hide in Developer](#hide-in-developer)                                           | Flags the table as hidden in Servoy Developer                                                                                                  |
| [Synchronize with DB Server Information](#synchronize-with-db-server-information) | Opens the [Database Synchronization Wizard](https://docs.servoy.com/reference/servoy-developer/object-editors/database-synchronization-wizard) |
| [Update Metadata](#update-metadata)                                               | Opens the [Metadata Synchronization Wizard](https://docs.servoy.com/reference/servoy-developer/object-editors/metadata-synchronization-wizard) |
| [Delete Table](#update-metadata)                                                  | 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](https://docs.servoy.com/reference/servoy-developer/object-editors/table-editor) to edit the table and its associated column information (metadata stored by Servoy Developer).

### Open SQL Editor

Opens [SQL Editor](https://docs.servoy.com/reference/servoy-developer/object-editors/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](https://docs.servoy.com/reference/servoy-developer/project-file-structure/workspace-folder/resources-directory/database-information-.dbi-files) in your project. This command will open the [database synchronization wizard](https://docs.servoy.com/reference/servoy-developer/object-editors/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.