SQL Data Types

This section 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 section do not work as shown, you may need to install or restore the example database with the DatabaseExamples` package.

Functions for retrieving information about tables.

This loads DatabaseLink and connects to the demo database.

In[1]:=

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

In[3]:=

Out[3]=

SQLDataTypeInformation returns more complete information about the data types.

In[4]:=

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

In[5]:=

This closes the connection.

In[6]:=

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