WOLFRAM

Wolfram Language & System Documentation Center

SQLColumnNames[conn]

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

SQLColumnNames[conn,table]

returns a list of the columns in table.

SQLColumnNames[conn,SQLTable[table]]

returns a list of the columns in table.

SQLColumnNames[conn,{table,column}]

returns a list of the columns in table matching column.

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

returns a list of the columns in table matching column.

SQLColumnNames[conn,SQLColumn[column]]

returns a list of 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`

SQLColumnNames

SQLColumnNames[conn]

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

SQLColumnNames[conn,table]

returns a list of the columns in table.

SQLColumnNames[conn,SQLTable[table]]

returns a list of the columns in table.

SQLColumnNames[conn,{table,column}]

returns a list of the columns in table matching column.

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

returns a list of the columns in table matching column.

SQLColumnNames[conn,SQLColumn[column]]

returns a list of the columns in any table matching column.

Details and Options

  • To use SQLColumnNames, 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: SQLColumnNames[conn]//Short

Get {table,column} pairs from tables whose names start with "SA":

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

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

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

Here is another way:

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

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

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

Equivalently:

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

Here is another way:

Wolfram Language code: SQLColumnNames[conn, SQLColumn["V%"]]

Extract just the column names:

Wolfram Language code: SQLColumnNames[conn, SQLTable["SAMPLETABLE1"]][[All, 2]]
Wolfram Language code: CloseSQLConnection[conn];