Creating an example database
After you log on to a security file, you can create a new database.
About this task
Every iBase database contains several types of information, such as:
| Type | Description |
|---|---|
| Database management information | Information on statistics and access control to the database. The statistics are held within the database. The separate security file can be used to make access control unique to one database or consistent across several databases. |
| Entities and links | iBase stores data that is organized as entity and
link types; link types define the relationship between entities. Fields are the basic building
blocks of the data, and their types vary in complexity. Note: Each entity and link type has a
separate table in the database. Entities and links are stored as records in those tables.
|
| Folder objects | Folder objects support the use of the database, for example, browse definitions, labeling schemes, sets, and queries. |
| Data sheets | You can define data sheets to enter specific types of data. |
Procedure
To create an example database:
Results
iBase Designer creates a database file with extension .idb in the folder
that contains the security file.
- For Microsoft™ Access databases, this file is the actual database.
- For SQL Server databases, this file is a connection file to the actual database that is managed by the server.