WOLFRAM

Wolfram Language & System Documentation Center

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
Details and Options Details and Options
Examples  
Basic Examples  
See Also
Tech Notes
Related Guides
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)

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

Open a connection:

Wolfram Language code: conn = OpenSQLConnection["demo"];
Wolfram Language code: SQLColumns[conn]//Short[#, 15]&

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

Wolfram Language code: SQLColumns[conn, "SA%"]

Get all columns from a particular table:

Wolfram Language code: SQLColumns[conn, SQLTable["SAMPLETABLE1"]]

Here is another way:

Wolfram Language code: SQLColumns[conn, {"SAMPLETABLE1", "%"}]

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

Wolfram Language code: SQLColumns[conn, {"%", "V%"}]

Equivalently:

Wolfram Language code: SQLColumns[conn, SQLColumn[{"%", "V%"}]]

Here is another way:

Wolfram Language code: SQLColumns[conn, SQLColumn["V%"]]
Wolfram Language code: CloseSQLConnection[conn];