SQLTable

SQLTable expressions hold information about the tables in a database. If you find that the examples in this section do not work as shown, you may need to install or restore the example database with the DatabaseExamples` package.

The TableType option is used to select the type of the table in the database.

An example demonstrating SQLTable expressions follows. This loads DatabaseLink and connects to the demo database.

In[1]:=

Now SQLTables is used to return a list of the tables in the database; they are returned as SQLTable expressions. In this example a pattern is given to match the names of the tables and the TableType option is set to return tables of all types.

In[3]:=

Out[3]=

This closes the connection.

In[4]:=

SQLTable expressions can also be used in commands as shown in the Data Command section.