Filter
Top Products
DataWindow Designer User’s Guide 51
CHAPTER 3
Managing the Database
About this chapter
This chapter describes how to manage the database from within
DataWindow Designer.
Contents
Before you begin
You work with relational databases in DataWindow Designer. If you are
not familiar with relational databases, you might want to consult an
introductory text, such as A Database Primer by C. J. Date.
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.
Topic Page
Working with database components 51
Managing databases 54
Using the Database painter 55
Creating and deleting an Adaptive Server Anywhere database 60
Working with tables 62
Working with keys 75
Working with indexes 79
Working with database views 81
Manipulating data 86
Creating and executing SQL statements 92
Controlling access to the current database 96