Top
Interstage Studio User's Guide
FUJITSU Software

8.1.2 Functions that Operate Databases

The functions that operate databases are included in the workbench.

Connecting to the Database

In order to connect to a database, create a connection profile. When connected, the database contents can be referenced.
For details, refer to "8.3.1 Connecting to the Database".

Referencing Database Contents

The tables, views, and other elements defined in a database can be referenced. Database contents can be referenced in the [Data Source Explorer] view.
For details, refer to "8.3.2 Referencing Database Contents".

Executing SQL

The SQL coded in the SQL file can be executed. The execution results can be checked in the [SQL Results] view.
For details, refer to "8.3.3 Executing SQL Statements".

Creating Tables

In the standard workbench, the SQL statement that creates tables can be created in a dialog box. The table can be created by executing this SQL statement.
For details, refer to "8.3.4 Creating Tables".

Deleting Tables

In the standard workbench, the SQL statement that deletes tables can be created. The table can be deleted by executing this SQL statement.
For details, refer to "8.3.5 Deleting Tables".

Updating Table Data

In the standard workbench, the table data can be edited using a table data editor.
For details, refer to "8.3.6 Updating Table Data".