Help

Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

Get the names of the tables from a database

Topic Labels: API
3390 2
cancel
Showing results for 
Search instead for 
Did you mean: 

Hello!
I am writing a script that will export all the data from a database into Json files.
With the API, I can easily get the column’s name and their values, but can’t get the table’s name!
For instance, I have a table named “People” with its attribute: name, address, age, etc…
I can get the attributes… but I want to get “People”.
So I wrote manually in the script their names, but it’s not very convenient as if, in the future, new tables will be created.
Is there any call I can do with the API? A “get” function or do something with the value of the records received?

I work with node.
Thank you and have a nice day everyone!

2 Replies 2

This. The lack of method in the API to reach multiple tables at any given time is extremely limiting.

I’m also facing this same issue. and i want to get all table names in a base.?
is this possible or not? as we get all table names in sql, mysql and oracle etc. e.g in mysql we get DB::select( “SHOW tables”); but in airtable im unable to do so.!!