Prism MetaDB

From Schema Evolution
Revision as of 15:19, 20 February 2009 by Schemaevolution (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

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	
          );
Personal tools