FM.QueryBaseTableNames
----------------------

Queries the base table names of all files currently open.

| Component | Version | macOS | Windows | Linux | Server | iOS SDK |
|---|---|---|---|---|---|---|
| [FM](component_FM.md) [FMSQL](component_FMSQL.md) | [3.1](newinversion31.md) | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes |

MBS( "FM.QueryBaseTableNames" { ; FileName } ) 

**MBS**( **"FM.QueryBaseTableNames";** /\* Queries the base table names of all files currently open. \*/  
**$FileName**) /\* Optional; The database file name to look into.  
If empty or missing, we look in current database.  
(new in 6.2)e.g. "Contacts" \*/ 

### Parameters

| Parameter | Description | Example | Flags |
|---|---|---|---|
| FileName | The database file name to look into.   If empty or missing, we look in current database.   (new in 6.2) | "Contacts" | Optional |

### Result

Returns names of tables separated by return.

### Description

Queries the base table names of all files currently open.  
May be limited to what you are allowed to access.  
See also [FM.QueryTableNames](FMQueryTableNames.md).  
  
Needs permissions to query your database schema via SQL.  
### Examples

Query tables in database Kontakte:

 MBS ( "FM.QueryBaseTableNames"; "Kontakte" )  
### See also

- [FM.ExecuteFileSQL](FMExecuteFileSQL.md)
- [FM.ExecuteSQL](FMExecuteSQL.md)
- [FM.QueryTableNames](FMQueryTableNames.md)
- [FM.TableStatistics](FMTableStatistics.md)

### Release notes

- **Version 14.5**
    - Improved [FM.QueryBaseTableNames](https://www.mbsplugins.eu/FMQueryBaseTableNames.shtml) to use newer API in FileMaker 21.0 and newer.

### Blog Entries

- [MBS FileMaker Advent calendar - Door 15 - Information about tables and base tables](https://www.mbsplugins.de/archive/2025-12-15/MBS_FileMaker_Advent_calendar_/monkeybreadsoftware_blog_filemaker)
- [MBS FileMaker Plugin, version 14.5pr4](https://www.mbsplugins.de/archive/2024-10-25/MBS_FileMaker_Plugin_version_1/monkeybreadsoftware_blog_filemaker)
- [Unlocking the Power of Database Analysis with MBS FileMaker Plugin Functions](https://www.mbsplugins.de/archive/2024-09-02/Unlocking_the_Power_of_Databas/monkeybreadsoftware_blog_filemaker)
- [Comparing Base Elements Plugin to MBS FileMaker Plugin](https://www.mbsplugins.de/archive/2017-10-24/Comparing_Base_Elements_Plugin/monkeybreadsoftware_blog_filemaker)
- [MBS FileMaker Plugin, version 6.2pr3](https://www.mbsplugins.de/archive/2016-04-05/MBS_FileMaker_Plugin_version_6/monkeybreadsoftware_blog_filemaker)
- [MBS Filemaker Plugin, version 3.1pr3](https://www.mbsplugins.de/archive/2012-12-17/MBS_Filemaker_Plugin_version_3/monkeybreadsoftware_blog_filemaker)

This function checks for a license.

Created 18th August 2014 , last changed 16th September 2021

  
[FM.PatchNotificationProblem](FMPatchNotificationProblem.md) - [FM.QueryCustomFunctionsList](FMQueryCustomFunctionsList.md)

[HTML Version](FMQueryBaseTableNames.shtml)