Library > Products > Pervasive.SQL > Pervasive.SQL 9.1 > Advanced Operations Guide > Pervasive.SQL Databases > Pervasive.SQL Database Tasks

PreviousAdvanced Operations Guide (9.1 revision 1) Next

Pervasive.SQL Database Tasks

Show this topic in Library frames

The following tasks pertain to databases.

For conceptual information on named databases, see Pervasive.SQL Database Concepts

To create a new database

  1. In PCC Pervasive.SQL Explorer, right-click on the database engine for which you want the new database.
  2. Click New4Database.

    3. The Create New Database dialog appears (see Figure 1-1).

  3. Provide a name for the database and a location (see Table 1-1, Identifier Restrictions by Identifier Type, ).

    4. The name cannot be the same as an existing DSN.

  4. Specify the additional options on the dialog as required for the database. See Table 1-8 for a discussion of the options.

To modify properties of a database

  1. In PCC Pervasive.SQL Explorer, right-click on the database engine for which you want to modify the properties, then click Properties

    .
  2. On the Properties dialog, click the tree node for which you want to specify properties:
  3. Set the specific properties as required.

To delete a database

You cannot delete the database to which you are currently logged in. See To log out from a database engine in Pervasive.SQL User's Guide.

If database security is set to "mixed" or "database," you must first remove the security. You cannot delete a database if security on it is set to "mixed" or "database." See To turn off security using database properties and To turn off security using a SQL statement .

  1. In PCC Pervasive.SQL Explorer, right-click on the database engine that you want to delete.
  2. Click Delete.
  3. Click Yes to confirm the deletion.

    4. The "Confirm DSN Removal" dialog appears.

  4. If you want to remove a DSN associated with the database, ensure that the DSN is check marked in the list.

    5. Note that multiple DSNs can be associated with one database. In such cases, you may remove the DSNs that you want and retain the ones that you want.

  5. Optionally, select the option Always remove associated DSN entries if you want PCC to set DSN removal as the default action.
    6. Note
    If you select the option, PCC no longer prompts you for DSN removal when you delete a database. PCC will automatically remove all DSNs associated with the database being deleted.

    If you decide later to turn off the option, in PCC click Window 4 Preferences 4 General.

Chapter contents
Publication contents

Prev topic: New Database GUI Reference
Next topic: Concepts of Database Maintenance