Table of Contents Previous Next


5 General Database Administration : 5.4 Creating and Maintaining Databases and Objects

Creating a database is easy in PEM: simply right click on any managed server’s Databases node and select Database… from the Create menu. After defining a database, you can create objects within the new database.
For example, to create a new table, right click on a Tables node, select Table… from the Create menu. When the New Table dialog opens, specify the attributes of the new table (see Figure 5.7).
Each object type is displayed in the tree control; right click on the node that corresponds to an object type to access the Create menu and create a new object, or select Properties from the context menu of a named node to perform administrative tasks for the highlighted object.

5 General Database Administration : 5.4 Creating and Maintaining Databases and Objects

Table of Contents Previous Next