MariaDB.Contents
Syntax
MariaDB.Contents(
MariaDB Data Source as text,
optional database as text,
optional CreateNavigationProperties as logical
) as table
Remarks
Returns a navigation table.
- Without a
databasename
, returns a table of databases on the specified MariaDB serverservername
. - With a
databasename
, returns or a table of tables and views from the specified MariaDB databasedatabasename
on the serverservername
.
databasename
can be provided in either of the input parameters:- In the MariaDB Data Source string after a semicolon. This approach allows using database-specific credentials. See details below.
- As the optional Database parameter. This approach allows using same credentials for all databases on the specified server
servername
.
CreateNavigationProperties
is a parameter for Odbc.DataSource.A logical value that sets whether to generate navigation properties on the returned tables. Navigation properties are based on foreign key relationships reported by the driver. These properties show up as “virtual” columns that can be expanded in the query editor, creating the appropriate join.
If calculating foreign key dependencies is an expensive operation for your driver, you may want to set this value to false.
Default: TRUE
Examples
Example #1
Returns a table of MariaDB tables and views functions from the MariaDB database <code>databasename</code> on server <code>servername</code>.
MariaDB.Contents("servername", "databasename")
Result:
#table({"Name", "Description", "Data", "Kind"}, {
{"airlines", null, #table(...), "Table"},
{"airports", null, #table(...), "Table"},
{"flights", null, #table(...), "Table"}
})
Example #2
Returns a table of databases on the specified MariaDB server using the default port 3306 to connect. Equivalent to <code>MariaDB.Contents("servername:3306")</code>.
MariaDB.Contents("servername")
Result:
#table({"Name", "Description", "Data", "Kind"}, {
{"mysql", null, #table(...), "Database"},
{"flights", null, #table(...), "Database"}
})
Example #3
Returns a table of databases on the specified MariaDB server <code>servername</code> using the provided port number <code>portnumber</code> to connect.
MariaDB.Contents("servername:portnumber")
Result:
#table({"Name", "Description", "Data", "Kind"}, {
{"mysql", null, #table(...), "Database"},
{"flights", null, #table(...), "Database"}
})
Example #4
Returns a table of MariaDB tables and views from the MariaDB database <code>databasename</code> on server <code>servername</code>. The result is similar to <code>MariaDB.Contents("servername", "databasename")</code>, but the string <code>servername;databasename</code> identifies a unique data source and allows using dedicated credentials for the database <code>databasename</code>.
MariaDB.Contents("servername;databasename")
Result:
#table({"Name", "Description", "Data", "Kind"}, {
{"airlines", null, #table(...), "Table"},
{"airports", null, #table(...), "Table"},
{"flights", null, #table(...), "Table"}
})