6. Managing a Distributed Database with StarView : Register Tables with StarView
Share this page                  
Register Tables with StarView
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--Define Database Objects to Ingres Star. However, StarView provides an easy way to search for, select, and register local tables in your distributed database.
StarView also allows you to delete the registration of these tables using the Remove operation. Removing the registration of a table from your distributed database does not affect the underlying tables in the local database. To delete the table from a local database, you must quit StarView and use the drop statement.
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.