8.1 Databases

8.1.1 Add a database

8.1.2 Standard actions on a database

8.1.3 Delete a database

8.1.4 Database Wizard

8.1.1 Add a database

To add a relational database to a folder, click  Add  |   Relational Database  . This will take you to a form, similar to the one for adding a document or folder, requesting a name for the new database. When you have specified the database's name you can either choose to create it or to use the wizard to generate additional content. For information on the wizard, see section 8.1.4. Once created, you will see the icon beside the name of your new database in your folder.

8.1.2 Standard actions on a database

A relational database can be renamed or its description edited in the same way that a document can be modified. They can also be copied and cut and pasted. Databases should be archived using  |  DB Archive  and not using the standard  Selected   |  Archive  action (see section 8.7.1).

Events are registered, stored and displayed on databases, their tables, queries and views in the same way as other Business Collaborator objects.

Access Rights can be set on databases, their tables, queries and views to permit or deny varying levels of access to users.

8.1.3 Delete a database

To delete a database, select the database in its parent folder's view and click  Selected  |  Delete  . The database will be moved to the waste bin from where it can be undeleted or destroyed if required.

8.1.4 Database Wizard

The database wizard will guide you through the process of creating a single table whilst automating the generation of a single query and view upon that table. The aim of the wizard is to simplify the creation of single table databases.

To use the database wizard you need to select  Add  |   Relational Database  , provide a name for your database and then click " Wizard ".

You will then be asked to provide a name for your first table and to specify how many fields your table should have. Clicking "Next" will allow you to proceed.

You will finally be asked to provide the name, field type and whether each field is required or otherwise. Once you are happy with your field specifications click "Finish" to generate the table, query and view.