# Viewing and configuring tables
The table list at the left of **Database View** contains the list of tables in the source database. You can filter the table list and assign tables modes to the tables.
You can use the [Structural Agent](/app/structural-agent/agent-about.md) to filter **Database View** to a specific table. For example:
* `Display the products table on Database View.`
* `Show me the stores and vendors tables on Database View.`
## Information in the table list
The table list is grouped by schema. You can expand and collapse the list of tables in each schema. This does not affect the displayed columns.
For a [file connector](/app/setting-up-your-database/file-connector.md) workspace, each table corresponds to a file group.
For each table, the table list includes the following information:
* The name of the table.
* The number of columns that have an assigned generator (a generator other than Passthrough).\
\
The number does not display if none of the table columns has an assigned generator.
* The [assigned table mode](#database-view-tables-assign-mode). The table list only shows the first letter of the table mode:
* D = De-identify
* T = Truncate
* P = Preserve Destination
* I = Incremental
For a child workspace, if the selected table mode overrides the parent workspace configuration, then the override icon displays.
Table that overrides the configuration from the parent workspace
To display [Table View](/app/generation/table-view.md) for a table, click the arrow icon to the right of the table entry.
## Filtering the table list
You can filter the table list [by name](#database-view-tables-filter-name) and [by the assigned table mode](#database-view-tables-filter-mode). You can also filter the tables based on [whether any of the columns have assigned generators](#database-view-tables-filter-has-generators).
As you filter the table list, the column list also is filtered to only include the columns for the filtered tables.
### Filtering by table name
To filter the table list by name, in the filter field, begin to type text that is in the table name.
As you type, Tonic Structural filters the list to only display tables with names that contain the filter text.
### Filtering by the assigned table mode
To filter the table list based on the assigned table mode:
1. Click **Filters**.
2. On the filter panel, check the checkbox next to each table mode to include.\
\
By default, the list includes all of the table modes.\
\
As you check and uncheck the table mode checkboxes, Structural adds and removes the associated tables from the list.
### Filtering to exclude tables that have assigned generators
You can filter the table list to only display tables that have no assigned generators:
1. Click **Filters**.
2. On the filter panel, to only show tables that do not have assigned generators, check the **No Generators Applied** checkbox.
## Assigning table modes to tables
{% hint style="info" %}
**Required workspace permission:** Assign table modes
{% endhint %}
The table mode determines the number of rows and columns in the destination database. For details about the available table modes and how they work, go to [Table modes](/app/generation/table-modes.md).
### Updating a single table
To change the assigned table mode for a single table:
1. Click the table mode dropdown next to the table name.
2. From the table mode dropdown list, select the table mode.
3. For a child workspace, the table mode selection panel indicates whether the selected table mode is inherited from the parent workspace.\
\
If the child workspace currently overrides the parent workspace configuration, then to reset the table mode to the table mode that is assigned in the parent workspace, click **Reset**.
### Updating multiple tables
To change the assigned table mode for multiple tables:
1. Check the checkbox for each table to change the table mode for.\
\
To select a continuous range of tables, click the first table in the range, then Shift-click the last table in the range.\
\
To select all of the tables in a schema, click the schema name.
2. Click **Bulk Edit**.
3. On the panel, click the radio button for the table mode to assign to the selected tables.
---
# Agent Instructions: Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.
Perform an HTTP GET request on the current page URL with the `ask` query parameter:
```
GET https://docs.tonic.ai/app/generation/database-view/database-view-tables.md?ask=
```
The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.
Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.