Neoview Database Administrator's Guide (R2.4)

For additional information, see DB Admin online help.
Changing Materialized View Groups
1. Start DB Admin and log on using the user ID that created the table or log on as a user
authorized to change that table.
2. Click the Database tab, then navigate to a schema and materialized view group in the left
pane.
3. Right-click the group name and then select Alter. DB Admin displays the Alter Materialized
View Group Wizard:
4. Select materialized views in the left or right panes and add or remove them using the buttons.
Click Finish when you are done. DB Admin confirms that you want to alter the materialized
view group. When you click Yes it either displays an error or indicates that the alter was
successful and displays the group’s DDL information.
For additional information, see DB Admin online help.
Dropping (Deleting) Materialized View Groups
1. Start DB Admin and log on using the user ID that created the table or log on as a user
authorized to change that table.
2. Click the Database tab, then navigate to a materialized view group in the left pane.
3. Right-click the materialized view group name and then select Drop. DB Admin prompts
you to confirm the drop. When you click Yes, it drops the materialized view group.
For additional information, see DB Admin online help.
Synonyms
A synonym is an alternate name that can replace multi-part or fully-qualified names for SQL
objects. You can refer to an object by its name or by the synonym. You can create, alter, and drop
synonyms. You can create synonyms only for tables.
Synonyms 81