WOLFRAM

Wolfram Language & System Documentation Center

SQLTableTypeNames[conn]

returns the types of table supported in an SQL connection.

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

SQLTableTypeNames

SQLTableTypeNames[conn]

returns the types of table supported in an SQL connection.

Details and Options

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.

Open a connection:

Wolfram Language code: conn = OpenSQLConnection["demo"];
Wolfram Language code: SQLTableTypeNames[conn]
Wolfram Language code: CloseSQLConnection[conn];

Applications  (1)

Wolfram Language code: Needs["DatabaseLink`"]

Get the names of all types of tables in a data source:

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