DatabaseLink Symbol

SQLColumns

SQLColumns[conn]
returns the SQLColumn objects for each column in an SQL connection.

To use SQLColumns, you first need to load DatabaseLink using Needs["DatabaseLink`"].

The following options can be given:

"Catalog"	None	database catalog to use
"Schema"	None	database schema to use

EXAMPLES

CLOSE ALL

Basic Examples (1)

Needs["DatabaseLink`"]

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, as described in Using the Example Databases.

In[2]:=

In[3]:=

Out[3]//Short=

Get all columns from tables whose names start with "SA":

In[4]:=

Out[4]=

Get all columns from a particular table:

Get columns whose names begin with "V" from all tables: