Data Types
This feature is not supported on the Wolfram Cloud.

This tutorial discusses how to retrieve information about data types. When you create a table, you will need to refer to these data types.

If you find that the examples in this tutorial do not work as shown, you may need to install or restore the example database with the package, as described in "Using the Example Databases".

SQLDataTypeNames[conn]list all data type names within a data source
SQLDataTypeInformation[conn]list all data type information within a data source

Functions for retrieving information about data types.

This loads DatabaseLink and connects to the demo database.

In[1]:=
Click for copyable input

SQLDataTypeNames returns a list of the data type names within a database.

In[2]:=
Click for copyable input
Out[2]=

SQLDataTypeInformation returns more complete information about the data types.

In[3]:=
Click for copyable input
Out[3]//TableForm=

SQLDataTypeInformation takes a single option: . This returns the column headings.

In[4]:=
Click for copyable input
Out[4]//TableForm=

This closes the connection.

In[5]:=
Click for copyable input

More information on working with data types is provided in "Data Type Mapping".