Difference between revisions of "Prism MetaDB"
From Schema Evolution
| Line 2: | Line 2: | ||
| − | *CREATE VIEW COLUMNS ( | + | *CREATE VIEW COLUMNS ( |
| − | * `schema_version`, | + | * `schema_version`, |
| − | * `schema_version_minor`, | + | * `schema_version_minor`, |
| − | * `TABLE_CATALOG`, | + | * `TABLE_CATALOG`, |
| − | * `TABLE_SCHEMA`, | + | * `TABLE_SCHEMA`, |
| − | * `TABLE_NAME`, | + | * `TABLE_NAME`, |
| − | * `COLUMN_NAME`, | + | * `COLUMN_NAME`, |
| − | * `ORDINAL_POSITION`, | + | * `ORDINAL_POSITION`, |
| − | * `COLUMN_DEFAULT`, | + | * `COLUMN_DEFAULT`, |
| − | * `IS_NULLABLE`, | + | * `IS_NULLABLE`, |
| − | * `DATA_TYPE`, | + | * `DATA_TYPE`, |
| − | * `CHARACTER_MAXIMUM_LENGTH`, | + | * `CHARACTER_MAXIMUM_LENGTH`, |
| − | * `CHARACTER_OCTET_LENGTH`, | + | * `CHARACTER_OCTET_LENGTH`, |
| − | * `NUMERIC_PRECISION`, | + | * `NUMERIC_PRECISION`, |
| − | * `NUMERIC_SCALE`, | + | * `NUMERIC_SCALE`, |
| − | * `CHARACTER_SET_NAME`, | + | * `CHARACTER_SET_NAME`, |
| − | * `COLLATION_NAME`, | + | * `COLLATION_NAME`, |
| − | * `COLUMN_TYPE`, | + | * `COLUMN_TYPE`, |
| − | * `COLUMN_KEY`, | + | * `COLUMN_KEY`, |
| − | * `EXTRA`, | + | * `EXTRA`, |
| − | * `PRIVILEGES`, | + | * `PRIVILEGES`, |
| − | * `COLUMN_COMMENT`, | + | * `COLUMN_COMMENT`, |
| − | * `SCHEMA_UNIQUE_NAME`, | + | * `SCHEMA_UNIQUE_NAME`, |
| − | * `TSTART`, | + | * `TSTART`, |
| − | * `TEND`, | + | * `TEND`, |
| − | * `STATE`, | + | * `STATE`, |
| − | * `ERROR_CODE`, | + | * `ERROR_CODE`, |
| − | * `ERROR_MSG`) | + | * `ERROR_MSG`) |
| − | *AS ( | + | *AS ( |
| − | * SELECT | + | * SELECT |
| − | * `MAJOR_ORDINAL_VERSION`, | + | * `MAJOR_ORDINAL_VERSION`, |
| − | * `MINOR_ORDINAL_VERSION`, | + | * `MINOR_ORDINAL_VERSION`, |
| − | * `TABLE_CATALOG`, | + | * `TABLE_CATALOG`, |
| − | * `SCHEMA_NAME`, | + | * `SCHEMA_NAME`, |
| − | * `TABLE_NAME`, | + | * `TABLE_NAME`, |
| − | * `COLUMN_NAME`, | + | * `COLUMN_NAME`, |
| − | * `ORDINAL_POSITION`, | + | * `ORDINAL_POSITION`, |
| − | * `COLUMN_DEFAULT`, | + | * `COLUMN_DEFAULT`, |
| − | * `IS_NULLABLE`, | + | * `IS_NULLABLE`, |
| − | * `DATA_TYPE`, | + | * `DATA_TYPE`, |
| − | * `CHARACTER_MAXIMUM_LENGTH`, | + | * `CHARACTER_MAXIMUM_LENGTH`, |
| − | * `CHARACTER_OCTET_LENGTH`, | + | * `CHARACTER_OCTET_LENGTH`, |
| − | * `NUMERIC_PRECISION`, | + | * `NUMERIC_PRECISION`, |
| − | * `NUMERIC_SCALE`, | + | * `NUMERIC_SCALE`, |
| − | * `CHARACTER_SET_NAME`, | + | * `CHARACTER_SET_NAME`, |
| − | * `COLLATION_NAME`, | + | * `COLLATION_NAME`, |
| − | * `COLUMN_TYPE`, | + | * `COLUMN_TYPE`, |
| − | * `COLUMN_KEY`, | + | * `COLUMN_KEY`, |
| − | * `EXTRA`, | + | * `EXTRA`, |
| − | * `PRIVILEGES`, | + | * `PRIVILEGES`, |
| − | * `COLUMN_COMMENT`, | + | * `COLUMN_COMMENT`, |
| − | * `SCHEMA_UNIQUE_NAME`, | + | * `SCHEMA_UNIQUE_NAME`, |
| − | * `TSTART`, | + | * `TSTART`, |
| − | * `TEND`, | + | * `TEND`, |
| − | * `STATE`, | + | * `STATE`, |
| − | * `ERROR_CODE`, | + | * `ERROR_CODE`, |
| − | * `ERROR_MSG` | + | * `ERROR_MSG` |
| − | * FROM | + | * FROM |
| − | * PRISM_COLUMNS c, PRISM_VERSIONS v | + | * PRISM_COLUMNS c, PRISM_VERSIONS v |
| − | * WHERE | + | * WHERE |
| − | * c.TABLE_SCHEMA = v.SCHEMA_UNIQUE_NAME AND | + | * c.TABLE_SCHEMA = v.SCHEMA_UNIQUE_NAME AND |
| − | * c.TABLE_CATALOG = v.CATALOG_NAME | + | * c.TABLE_CATALOG = v.CATALOG_NAME |
| − | * ); | + | * ); |
Revision as of 15:18, 20 February 2009
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 * );
