DatabaseMetaData.getTableTypes

DatabaseMetaData.getTableTypes

Interface Overview | Interface Members | This Package | All Packages

Syntax
public abstract ResultSet getTableTypes() throws SQLException
Returns
ResultSet - each row has a single String column that is a table type
Description
Get the table types available in this database. The results are ordered by table type.

The table type is:

  1. TABLE_TYPE String => table type. Typical types are "TABLE", "VIEW", "SYSTEM TABLE", "GLOBAL TEMPORARY", "LOCAL TEMPORARY", "ALIAS", "SYNONYM".

Exceptions
SQLException if a database-access error occurs.