list tables in database
I'm trying to figure out (unsuccessfully) how to create a table listing all the tables in the database. a bit like querying an sql information_schema. Any help would be much appreciated!
Andrew
6 replies
-
Andrew,
If you are using Ninox Cloud, you should look at their REST API documentaion.
-
Hmmm... I'm working locally so I'm not sure if or how this would apply?
-
If you're working locally, it won't apply unless you are running Ninox on your own server.
-
Ok, thanks. Is there nothing in a formula I could employ to ask the database to give up its list of tables? I understand the do notation for pulling fields out of tables. Is there no way of treating the Ninox database like an conventional RDBMS database with sql queries?
-
Here is a list of functions and commands...
https://ninox.com/en/manual/calculations/reference-of-functions-and-language
I don't understand what you mean by "pulling fields out of tables" in the context of Ninox. You either need to know the names of fields or get them from the UI in the formula editor or field editor. The SQL-like commands available in the "native" apps are very limited.
-
Ok thanks for helping. I've made a change in my database which I think will help me not have to query the schema
Content aside
- 3 yrs agoLast active
- 6Replies
- 443Views