Skip to main content
SQLTypes

ON THIS PAGE

SQLTypes

The sqltypes statement returns a set of fields describing the types of an ODBC or OLE DB data source, to which a connect has been made.

Syntax:  

SQLTypes

 

The fields can be combined with the fields generated by the sqlcolumns and sqltables commands in order to give a good overview of a given database. The fifteen standard fields are:

TYPE_NAME

DATA_TYPE

PRECISION

LITERAL_PREFIX

LITERAL_SUFFIX

CREATE_PARAMS

NULLABLE

CASE_SENSITIVE

SEARCHABLE

UNSIGNED_ATTRIBUTE

MONEY

AUTO_INCREMENT

LOCAL_TYPE_NAME

MINIMUM_SCALE

MAXIMUM_SCALE

For a detailed description of these fields, see an ODBC reference handbook.

Example:  

Connect to 'MS Access 7.0 Database; DBQ=C:\Course3\DataSrc\QWT.mbd';

SQLTypes;

Information noteSome ODBC drivers may not support this command. Some ODBC drivers may produce additional fields.

Join the Analytics Modernization Program

Remove banner from view

Modernize without compromising your valuable QlikView apps with the Analytics Modernization Program. Click here for more information or reach out: ampquestions@qlik.com