Prism MetaDB
From Schema Evolution
Revision as of 15:18, 20 February 2009 by Schemaevolution (Talk | contribs)
This is an informal page to describe the PRISM metaDB
- CREATE VIEW COLUMNS (
- `schema_version`,
- `schema_version_minor`,
- `TABLE_CATALOG`,
- `TABLE_SCHEMA`,
- `TABLE_NAME`,
- `COLUMN_NAME`,
- `ORDINAL_POSITION`,
- `COLUMN_DEFAULT`,
- `IS_NULLABLE`,
- `DATA_TYPE`,
- `CHARACTER_MAXIMUM_LENGTH`,
- `CHARACTER_OCTET_LENGTH`,
- `NUMERIC_PRECISION`,
- `NUMERIC_SCALE`,
- `CHARACTER_SET_NAME`,
- `COLLATION_NAME`,
- `COLUMN_TYPE`,
- `COLUMN_KEY`,
- `EXTRA`,
- `PRIVILEGES`,
- `COLUMN_COMMENT`,
- `SCHEMA_UNIQUE_NAME`,
- `TSTART`,
- `TEND`,
- `STATE`,
- `ERROR_CODE`,
- `ERROR_MSG`)
- AS (
- SELECT
- `MAJOR_ORDINAL_VERSION`,
- `MINOR_ORDINAL_VERSION`,
- `TABLE_CATALOG`,
- `SCHEMA_NAME`,
- `TABLE_NAME`,
- `COLUMN_NAME`,
- `ORDINAL_POSITION`,
- `COLUMN_DEFAULT`,
- `IS_NULLABLE`,
- `DATA_TYPE`,
- `CHARACTER_MAXIMUM_LENGTH`,
- `CHARACTER_OCTET_LENGTH`,
- `NUMERIC_PRECISION`,
- `NUMERIC_SCALE`,
- `CHARACTER_SET_NAME`,
- `COLLATION_NAME`,
- `COLUMN_TYPE`,
- `COLUMN_KEY`,
- `EXTRA`,
- `PRIVILEGES`,
- `COLUMN_COMMENT`,
- `SCHEMA_UNIQUE_NAME`,
- `TSTART`,
- `TEND`,
- `STATE`,
- `ERROR_CODE`,
- `ERROR_MSG`
- FROM
- PRISM_COLUMNS c, PRISM_VERSIONS v
- WHERE
- c.TABLE_SCHEMA = v.SCHEMA_UNIQUE_NAME AND
- c.TABLE_CATALOG = v.CATALOG_NAME
- );