Table of Contents Previous Next

4 General Database Administration : 4.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 the New Database… menu option. You can also access the New Database dialog by navigating through the Edit menu (on the Main menu) to the New Object menu, and selecting New Database.
Once you have defined a database, you can create objects within the new database. Note that within each database there exist one or more schemas. A schema can be thought of as a directory of an operating system disk; it allows the logical separation of database objects (i.e. tables, indexes, SQL functions, and more) inside of a database.
For example, to create a new table, right click on a Table node, select New Table… from the context menu. When the New Table dialog opens, specify the attributes of the new table (see Figure 4.3).
Screen shot 2013-09-19 at 6

4 General Database Administration : 4.4 Creating and Maintaining Databases and Objects

Table of Contents Previous Next