WOLFRAM

Wolfram Language & System Documentation Center
Wolfram Language Home Page »
DatabaseLink`
DatabaseLink`

SQLColumns

SQLColumns[conn]

returns the SQLColumn object for each column in an SQL connection.

SQLColumns[conn,table]

returns the columns in table.

SQLColumns[conn,SQLTable[table]]

returns the columns in table.

SQLColumns[conn,{table,column}]

returns the columns in table matching column.

SQLColumns[conn,SQLColumn[{table,column}]]

returns the columns in table matching column.

SQLColumns[conn,SQLColumn[column]]

returns the columns in any table matching column.

Details and Options

  • To use SQLColumns, you first need to load DatabaseLink using Needs["DatabaseLink`"].
  • Table and column specifications may include SQL wildcards.
  • The following options can be given:
  • "Catalog"Nonedatabase catalog to use
    "Schema"Nonedatabase schema to use

Examples

Basic Examples  (1)Summary of the most common use cases

Copy to clipboard.
In[1]:=1
✖
https://wolfram.com/xid/0c3qvknck6aq878-cpgy6d
Direct link to example

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 "DatabaseLink`DatabaseExamples`" package, as described in Using the Example Databases.

Open a connection:

Copy to clipboard.
In[2]:=2
✖
https://wolfram.com/xid/0c3qvknck6aq878-pko
Direct link to example
Copy to clipboard.
In[3]:=3
✖
https://wolfram.com/xid/0c3qvknck6aq878-mo8
Direct link to example

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

Copy to clipboard.
In[4]:=4
✖
https://wolfram.com/xid/0c3qvknck6aq878-biu
Direct link to example
Out[4]=4

Get all columns from a particular table:

Copy to clipboard.
In[5]:=5
✖
https://wolfram.com/xid/0c3qvknck6aq878-ft5
Direct link to example
Out[5]=5

Here is another way:

Copy to clipboard.
In[6]:=6
✖
https://wolfram.com/xid/0c3qvknck6aq878-nuv
Direct link to example
Out[6]=6

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

Copy to clipboard.
In[7]:=7
✖
https://wolfram.com/xid/0c3qvknck6aq878-n27
Direct link to example
Out[7]=7

Equivalently:

Copy to clipboard.
In[8]:=8
✖
https://wolfram.com/xid/0c3qvknck6aq878-xo4526
Direct link to example
Out[8]=8

Here is another way:

Copy to clipboard.
In[9]:=9
✖
https://wolfram.com/xid/0c3qvknck6aq878-c8c
Direct link to example
Out[9]=9
Copy to clipboard.
In[10]:=10
✖
https://wolfram.com/xid/0c3qvknck6aq878-n5l
Direct link to example