Databases

A database is a collection of data stored together. Newly created databases are empty and may be populated with tables. Refer to the chapter Pervasive.SQL Databases in Advanced Operations Guide for a detailed discussion of databases. That chapter also contains the following fundamental tasks pertaining to databases:

To create a new database

To modify properties of a database

To delete a database

The properties of a database include such items as file locations, referential constraints, security, and whether the database is bound.

Note
If you wish to add a database to a Server engine, you must have administrative rights on the server operating system. If you do not have administrative rights, you will not be permitted to add the database.

To log out from a database

In Pervasive.SQL Explorer, expand the Engines node in the tree (click the icon to the left of the node).

Expand the node for the registered server to display the databases on that server.

Right-click on the database from which you want to log out.

Click Logout (name).

Name reflects the name of the user currently logged in to the database. If the database does not have security enabled, name is Master. Name may also be Master if the current user is logged in as Master.

Any nodes expanded for the database are collapsed.

Database Properties

See Database Properties in Advanced Operations Guide.