To do this

Do this

Modify a database profile

Highlight a database profile and select Properties from the Object or popup menu or use the Properties button. Or use the new Import and Export Profiles menu selections to copy profiles. For more information, see Importing and exporting database profiles

Connect to a database

Highlight a database profile and then select Connect from the File or popup menu or use the Connect button. With File>Recent Connections you can review and return to earlier connections. Database connections can also be made via the Database Profile button

Create new profiles, tables, views, columns, keys, indexes, and groups

Highlight the database object and select New from the Object or popup menu or use the Create button

Modify database objects

Drag the object to the Object Details view

Graphically display tables

Drag the table icon from the list in the Objects view to the Object Layout view or highlight the table and select Add to Layout from the Object or popup menu

Manipulate data

Highlight the table and select Grid, Tabular, or Freeform from the Object>Data menu or the popup menu Edit Data item or use the appropriate Data Manipulation button

Build, execute, or explain SQL

Use the ISQL view to build SQL statements. Use the Paste SQL button to paste SELECT, INSERT, UPDATE, and DELETE statements or type them directly into the view's workspace. To execute or explain SQL, select Execute SQL and Explain SQL from the Design or popup menu

Define or modify extended attributes

Select the type of extended attribute you want to define or modify from Object>Insert menu, or highlight the extended attributed from the list in the Extended Attributes view and select New or Properties from the popup menu

Specify extended attributes for a column

Drag the column to the Object Details view and select the Extended Attributes tab

Access database utilities

Double-click a utility in the Objects view to launch it

Log your work

Select Start Log from the Design menu. To see the SQL syntax generated by the actions executed in the Database painter, display the Activity Log view