WOLFRAM

Wolfram Language & System Documentation Center

SQLDataTypeInformation[conn]

returns information about the data types that can be stored in an SQL connection.

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

SQLDataTypeInformation

SQLDataTypeInformation[conn]

returns information about the data types that can be stored 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: SQLDataTypeInformation[conn]//TableForm
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)

"ShowColumnHeadings"  (1)

Wolfram Language code: Needs["DatabaseLink`"]
Wolfram Language code: conn = OpenSQLConnection["demo"];
Wolfram Language code: SQLDataTypeInformation[conn, "ShowColumnHeadings" -> True]//TableForm
Wolfram Language code: CloseSQLConnection[conn];