DatabaseLink`
DatabaseLink`

SQLDataTypeInformation

SQLDataTypeInformation[conn]

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

Details and Options

  • To use SQLDataTypeInformation, you first need to load DatabaseLink using Needs["DatabaseLink`"].
  • The following option can be given:
  • "ShowColumnHeadings" Falsewhether to return headings with the results

Examples

open allclose all

Basic Examples  (1)

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:

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)