Skip to main content
SQLTables

ON THIS PAGE

SQLTables

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

Syntax:  

SQLTables

 

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

TABLE_QUALIFIER

TABLE_OWNER

TABLE_NAME

TABLE_TYPE

REMARKS

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';

SQLTables;

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