# Get table names

## ![](/files/BvSZKJfPua2n3PVwGwwd) Get table names

### Description <a href="#description" id="description"></a>

The Get Table Names transform gets table names from a database connection.

| Hop Engine | <sup>✓</sup> |
| ---------- | ------------ |
| Spark      | ?            |
| Flink      | ?            |
| Dataflow   | ?            |

### Options

| Option                     | Description                                                          |
| -------------------------- | -------------------------------------------------------------------- |
| Transform name             | Name of this transform as it appears in the pipeline workspace       |
| Connection                 | The connection to use                                                |
| Schema name                | The schema to use                                                    |
| Get schema from field      | Allows passing a field containing the schema name                    |
| Schema name field          | The field containing the schema name                                 |
| Include catalogs           | Includes catalogs in the output                                      |
| Include schemas            | Includes schemas in the output                                       |
| Include views              | Includes views in the output                                         |
| Include procedures         | Includes procedures in the output                                    |
| Include synonyms           | Include synonyms in the output                                       |
| Add schema in object name  | Adds the schema to the object name                                   |
| Tablename fieldname        | Output field containing the table name                               |
| Object type fieldname      | Output field containing the object type (catalog, schema, table, …​) |
| Is system object fieldname | Output field containing boolean: is object a system object           |
| Creation SQL fieldname     | Output field containing create statement for object                  |


---

# 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.primeur.com/data-shaper-1.21/knowing-the-data-shaper-designer/pipelines/transforms/gettablenames.md?ask=<question>
```

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.