DataWindow Designer supports many database management systems (DBMSs). For the most part, you work the same way in DataWindow Designer for each DBMS, but because each DBMS provides some unique features (which DataWindow Designer makes use of), there are some issues that are specific to a particular DBMS. For complete information about using your DBMS, see Connecting to Your Database.
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
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.
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.
For more about changing the database you are connected to, see Connecting to Your Database.
When you are connected to SQL 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.
