Neoview Database Administrator's Guide (R2.2)

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.
Creating Synonyms
1. Start DB Admin and log on using any user ID that is authorized to access the table for which
you want to create a synonym.
2. Click the Database tab, then navigate to a schema in the left pane. Right-click the schema
name or a table name and then select Create Synonym to start the Create Synonym Wizard.
Or, you can click Create a synonym in the right pane. Enter a name for the synonym and
click Next:
3. Select the object for which you want to create the synonym:
4. DB Admin prompts you to confirm that you want to create this synonym. When you click
Yes, it attempts to create the synonym and either displays an error or indicates that the
creation was successful and displays its information.
72 Managing Database Objects