Schema and Catalogs
This feature is not supported on the Wolfram Cloud.

Database schema and catalogs can be used to hold collections of database components and objects suitable for particular users. They can be particularly useful when working with large databases. The functions SQLSchemaNamesand SQLCatalogNames can be used to learn the names of the schema and catalogs in the database. These can be used with the and options to SQLTableNames, SQLTableInformation, SQLTables, SQLColumnNames, SQLColumnInformation, and SQLColumns to focus attention on particular parts of the database.

SQLCatalogNames[conn]list all the catalogs used in a data source
SQLSchemaNames[conn]list all the schema used in a data source
SQLSchemaInformation[conn]return information about the schema used in a data source

Listing catalogs and schema.

If you find that the examples in this tutorial do not work as shown, you may need to install or restore the example database with the package, as described in "Using the Example Databases".

First, the DatabaseLink package is loaded and a connection is made to the publisher example database.

In[1]:=
Click for copyable input

This returns the schema names for the connection.

In[2]:=
Click for copyable input
Out[2]=

SQLSchemaInformation returns more information about the database schema.

In[3]:=
Click for copyable input
Out[3]=

This returns the catalog names; for this database there are no catalogs.

In[4]:=
Click for copyable input
Out[4]=
In[5]:=
Click for copyable input