Filter
Top Products
CHAPTER 3 Managing the Database
DataWindow Designer User’s Guide 55
What you can do
Using the Database painter, you can do the following in any DBMS to which
you have been given access by the database administrator:
• Modify local table and column properties
• Retrieve, change, and insert data
• Create new local tables or modify existing tables
Setting the database
connection
When you open a painter that communicates with the database (such as the
Database painter or DataWindow painter), DataWindow Designer connects
you to the database you used last if you are not already connected. If the
connection to the default database fails, the painter still opens.
If you do not want to connect to the database you used last, you can deselect
the Connect to Default Profile option in the Database Preferences dialog box.
Changing the
database connection
You can change to a different database at any time. You can have several
database connections open at a time, although only one connection can be
active. The database components for each open connection are listed in the
Objects view.
The Database painter title bar displays the number of open connections and
shows which is active. The title bar for each view displays the connection with
which it is currently associated. You can change the connection associated with
a view by dragging the profile name for a different connection onto the view.
For more about changing the database you are connected to, see Connecting to
Your Database.
Creating and deleting
databases
When you are connected to Adaptive Server Anywhere, you can create a new
database or delete an existing database using the Database painter.
For all other DBMSs, creating and deleting a database is an administrative task
that you cannot do within DataWindow Designer.
Using the Database painter
To open the Database painter, click the Database button in the PowerBar.
About the painter
Like the other DataWindow Designer painters, the Database painter contains a
menu bar, customizable PainterBars, and several views. All database-related
tasks that you can do in DataWindow Designer can be done in the Database
painter.