SQLColumn

SQLColumn expressions hold information about the columns 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.

Here is an example demonstrating SQLColumn expressions. This loads DatabaseLink and connects to the demo database.

In[1]:=

SQLColumns returns a list of the columns in the database as SQLColumn expressions. In this example a pattern is given to pick out just the SAMPLETABLE1 table.

In[3]:=

Out[3]=

This closes the connection.

In[4]:=

SQLColumn expressions can also be used in commands as discussed in the Data Command section. The Creating Tables section discusses one important use.