Specifications

Users Guide 73
CHAPTER 3
Managing the Database
About this chapter
This chapter describes how to manage a database from within InfoMaker.
Contents
Before you begin
You work with relational databases in InfoMaker. If you are not familiar
with relational databases, you might want to consult an introductory text.
Working with database components
A database is an electronic storage place for data. Databases are designed
to ensure that data is valid and consistent and that it can be accessed,
modified, and shared.
A database management system (DBMS) governs the activities of a
database and enforces rules that ensure data integrity. A relational DBMS
stores and organizes data in tables.
How you work with
databases in InfoMaker
You can use InfoMaker to work with the following database components:
• Tables and columns
•Keys
Topic Page
Working with database components 73
Managing databases 77
Using the Database painter 78
Creating and deleting a SQL Anywhere database 83
Working with tables 84
Working with keys 97
Working with indexes 101
Working with database views 103
Manipulating data 108
Creating and executing SQL statements 115
Controlling access to the current database 119