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" False whether to return headings with the results

Examples

open allclose all

Basic Examples (1)Summary of the most common use cases

In[1]:=1

✖

https://wolfram.com/xid/02fqz2x648gagrouqba-c5duw4

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:

In[2]:=2