WOLFRAM

Wolfram Language & System Documentation Center

SQLTables[conn]

returns the SQLTable objects for each table in an SQL connection.

SQLTables[conn,table]

returns objects for tables matching table.

Details and Options
Details and Options Details and Options
Examples  
Basic Examples  
Options  
"TableType"  
See Also
Tech Notes
Related Guides
DatabaseLink`
DatabaseLink`

SQLTables

SQLTables[conn]

returns the SQLTable objects for each table in an SQL connection.

SQLTables[conn,table]

returns objects for tables matching table.

Details and Options

  • To use SQLTables, you first need to load DatabaseLink using Needs["DatabaseLink`"].
  • The following options can be given:
  • "Catalog"Nonedatabase catalog to use
    "Schema"Nonedatabase schema to use
    "TableType" "TABLE"type of table to return

Examples

open all close all

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.

Wolfram Language code: conn = OpenSQLConnection["publisher"];

List all the tables:

Wolfram Language code: SQLTables[conn]

Get a specific table by name:

Wolfram Language code: SQLTables[conn, "AUTHORS"]

Get the tables that match a pattern:

Wolfram Language code: SQLTables[conn, "TITLE%"]
Wolfram Language code: CloseSQLConnection[conn];

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.

Options  (1)

"TableType"  (1)

Wolfram Language code: Needs["DatabaseLink`"]

Get all types of tables in a data source:

Wolfram Language code: conn = OpenSQLConnection["publisher"];
Wolfram Language code: SQLTables[conn, "TableType" -> SQLTableTypeNames[conn]]
Wolfram Language code: CloseSQLConnection[conn];