MAPINFO_MAPCATALOG Table Structure

MAPINFO_MAPCATALOG has the following table structure:

	SPATIALTYPE FLOAT
	TABLENAME CHAR(32)
	OWNERNAME CHAR(32)
	SPATIALCOLUMN CHAR(32)
	DB_X_LL FLOAT
	DB_Y_LL FLOAT
	DB_X_UR FLOAT
	DB_Y_UR FLOAT
	VIEW_X_LL FLOAT
	VIEW_Y_LL FLOAT
	VIEW_X_UR FLOAT
	VIEW_Y_UR FLOAT
	COORDINATESYSTEM CHAR(254)
	SYMBOL CHAR(254)
	XCOLUMNNAME CHAR(32)
	YCOLUMNNAME CHAR(32)
	RENDITIONTYPE INTEGER
	RENDITIONCOLUMN CHAR(32)
	RENDITIONTABLE CHAR(32)
	NUMBER_ROWS INTEGER

The following script may be used to modify an existing MAPINFO.MAPINFO_MAPCATALOG to add the rendition columns if they do not exist. Run this script as user MAPINFO.

	ALTER TABLE MAPINFO.MAPINFO_MAPCATALOG ADD RENDITIONTYPE INTEGER;
	ALTER TABLE MAPINFO.MAPINFO_MAPCATALOG ADD RENDITIONCOLUMN CHAR(32);
	ALTER TABLE MAPINFO.MAPINFO_MAPCATALOG ADD RENDITIONTABLE CHAR(32);