Mimer SQL Reference Manual TOC PREV NEXT INDEX

Mimer Developer Site

www.mimer.com/developer


TABLES


The TABLES system view lists the tables and views on which the current ident, or PUBLIC, holds one or more privileges (INSERT, DELETE or SELECT; or REFERENCES or UPDATE on one or more columns).

Column name
Data type
Description
TABLE_CAT
VARCHAR(128)
The name of the catalog containing the table or view.
TABLE_SCHEM
VARCHAR(128)
The name of the schema containing the table or view.
TABLE_NAME
VARCHAR(128)
The name of the table or view.
TABLE_TYPE
VARCHAR(20)
One of:
"BASE TABLE" = the row describes a table
"VIEW" = the row describes a view.
REMARKS
VARCHAR(254)
May contain descriptive information about the table.



Upright Database Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40
dbtechnology@upright.se
Mimer SQL Reference Manual TOC PREV NEXT INDEX