DatabaseLink Symbol

SQLColumnNames

SQLColumnNames[conn]
returns a list of {table, name} pairs for each column in an SQL connection.

To use SQLColumnNames, 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 {table, column} pairs from tables whose names start with "SA":

In[4]:=

Out[4]=

Get {table, column} pairs from a particular table:

Get {table, column} pairs for columns whose names begin with "V" in any table:

Extract just the column names:

In[10]:=

Out[10]=

In[11]:=