Prism MetaDB
From Schema Evolution
Revision as of 15:19, 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 );