DatabaseLink Paclet Symbol

SQLColumnInformation

SQLColumnInformation[conn]
returns a list of information about the columns in an SQL connection.

To use SQLColumnInformation, 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
"ShowColumnHeadings"	False	whether to return headings with the results

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 information for all columns from tables whose names start with "SA":

In[4]:=

Out[4]//TableForm=

Get information for all columns from a particular table:

In[5]:=

Out[5]//TableForm=

Here is another way:

In[6]:=

Out[6]//TableForm=

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

In[7]:=

Out[7]//TableForm=

Here is another way:

In[8]:=

Out[8]//TableForm=

In[9]:=

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.

Options (1)