WOLFRAM

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

SQLColumnInformation

SQLColumnInformation[conn]

returns a list of information about the columns in an SQL connection.

SQLColumnInformation[conn,table]

returns a list pertaining to the columns in table.

SQLColumnInformation[conn,SQLTable[table]]

returns a list pertaining to the columns in table.

SQLColumnInformation[conn,{table,column}]

returns a list pertaining to the columns in table matching column.

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

returns a list pertaining to the columns in table matching column.

SQLColumnInformation[conn,SQLColumn[column]]

returns a list pertaining to the columns in any table matching column.

Details and Options

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

Examples

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

In[1]:=1
✖
https://wolfram.com/xid/0hbngqf9h7oj54tkhw2-t0dnw

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:

In[2]:=2
✖
https://wolfram.com/xid/0hbngqf9h7oj54tkhw2-lho
In[3]:=3
✖
https://wolfram.com/xid/0hbngqf9h7oj54tkhw2-x9u

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

In[4]:=4
✖
https://wolfram.com/xid/0hbngqf9h7oj54tkhw2-hvw

Get information for all columns from a particular table:

In[5]:=5
✖
https://wolfram.com/xid/0hbngqf9h7oj54tkhw2-q6x

Here is another way:

In[6]:=6
✖
https://wolfram.com/xid/0hbngqf9h7oj54tkhw2-wb6

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

In[7]:=7
✖
https://wolfram.com/xid/0hbngqf9h7oj54tkhw2-xb6

Equivalently:

In[8]:=8
✖
https://wolfram.com/xid/0hbngqf9h7oj54tkhw2-6ztl12

Here is another way:

In[9]:=9
✖
https://wolfram.com/xid/0hbngqf9h7oj54tkhw2-lj9
In[10]:=10
✖
https://wolfram.com/xid/0hbngqf9h7oj54tkhw2-uyo

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.