dodbmeta.php

This script is a wrapper for scripts returning database meta data in result set format.

dodbmeta.php processes the following HTTP parameters:

PHPSESSID
(required) the session ID returned from dologin.php
meta
(required) the type of meta data requested. Must be one of the names in the table below.
format
(optional) the format used to transmit the SQL result set. Can be either xml (default) or csv.
delimiter
(optional) the column delimiter used for CSV downloads. Default is a semicolon (;).
quote
(optional) the quote character used to enclose complex column values in CSV format. Defaults to a double quote (").

There may be more parameters depending on the type of meta data request.

The response structure returned by dodbmeta.php is the same as for dosql.php. Table structures of the meta data returned are described for each type below.

meta=Information returned
catalogscatalogs and their properties
columnscolumns of a table and their properties
indexesindexes of a table and their properties
schemasschemas in database and their properties
tablestables and their properties
tbltypestables and pseudo table types supported by database
typeinfotypes supported by database
Meta Data Types

meta=catalogs

This meta data request returns information about the database's catalogs and their properties. It has no specific parameters.

The result set returned is described in DatabaseMetaData.getCatalogs() of the Java API.

meta=columns

This meta data request returns information about the columns of a table in the database. Additional parameters are:

catalog
(optional) catalog of the table
schema-pattern
(optional) schema name pattern
name-pattern
table name pattern
column-name-pattern
(optional) column name pattern

More information about the parameters and the result set returned is described in DatabaseMetaData.getColumns() of the Java API.

meta=indexes

This meta data request returns information about the indexes of a table in the database. Additional parameters are:

catalog
(optional) catalog of the table
schema
(optional) schema of the table
table
table name
unique
when true, return only indices for unique values; when false, return indices regardless of whether unique or not
approximate
when true, result is allowed to reflect approximate or out of data values; when false, results are requested to be accurate

More information about the parameters and the result set returned is described in DatabaseMetaData.getIndexInfo() of the Java API.

meta=schemas

This meta data request returns information about schemas in the database. It has no additional parameters.

Information about the result set returned is described in DatabaseMetaData.getSchemas() of the Java API.

meta=tables

This meta data request returns information about tables in the database. Additional parameters are:

catalog
(optional) catalog of the table
types
(optional) schema of the table
schema-pattern
(optional) schema name pattern
name-pattern
table name pattern

More information about the parameters and the result set returned is described in DatabaseMetaData.getTables() of the Java API.

meta=tbltypes

This meta data request returns table types used in the database. It has no additional parameters.

More information about the parameters and the result set returned is described in DatabaseMetaData.getTableTypes() of the Java API.

meta=typeinfo

Retrieves a description of all the data types supported by this database. It has no additional parameters.

More information about the parameters and the result set returned is described in DatabaseMetaData.getTypeInfo() of the Java API.