Prism MetaDB
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
);