Note:  Populate a distributed database with tables that already exist in local databases by registering those tables in your distributed database. To do this, use the Register as Link Statement (see page Register as Link Statement—Define Database Objects to Ingres Star). However, StarView provides an easy way to search for, select, and register local tables in your distributed database.

Note:  Ingres Star does not support ALTER TABLE RENAME or RENAME TABLE statements for renaming tables and columns. If a table is registered in Star and it is renamed in the local database, any SELECT statements from the old table name will fail with error E_US0845 table does not exist. Similarly, if a column of a registered table is renamed in the local database, any SELECT statements involving that table column will fail with error E_US0834 table does not contain the column specified. Table and column names are recorded in the iiregistrations catalog, which you can access with the StarView utility. If you renamed a table or column registered in Ingres Star using one of these commands, you must drop the old table and register the new table name with the Ingres Star database using StarView.