Tables
Retrieves a list of tables available in Airtable bases, including their identifiers, names, descriptions, primary fields, associated fields, and related views.
View-Specific Information
SELECT Examples
SELECT * FROM [Information].[Tables]
SELECT * FROM [Information].[Tables] WHERE BaseId = 'appWJ6DP3C7Guh9fS'
Columns
| Name | Type | Description |
| BaseId [KEY] | String | The unique identifier for the Airtable base that contains the table and defines its structure and data. |
| BaseName | String | The display name of the base as shown in the Airtable interface, helping identify where the table belongs. |
| Id [KEY] | String | The unique identifier assigned to the table within its base, used to reference the table in API calls and integrations. |
| Name | String | The display name of the table as defined in the base, typically reflecting the type of data it stores. |
| Description | String | A descriptive summary explaining the table’s purpose, the type of records it contains, or how it is used within workflows. |
| PrimaryFieldId | String | The unique identifier for the table’s primary field, which acts as the main reference column and is often used for record naming or linking. |
| Fields | String | A collection of fields (columns) that make up the table, including details such as field names, data types, formatting, and configuration options. |
| Views | String | A collection of views created from the table, each offering a specific way to display, filter, sort, or group the table’s records. |