Top
Interstage Studio User's Guide
FUJITSU Software

8.3.5 Deleting Tables

In the standard workbench, the SQL statement that deletes tables can be created.

Connecting to the Database

Connect to the database. For details on database connection, refer to "8.3.1 Connecting to the Database".

Generating SQL Statements

Generate the SQL statements that delete the table. Select the table you want to display under [Tables] in the [Data Source Explorer] view, then select [Delete] from the context menu.

Executing SQL Files

SQL statements are generated to the SQL File editor, and executed from the SQL File editor. For details on executing an SQL file, refer to "8.3.3 Executing SQL Statements".

When SQL is executed, the results are displayed in the [SQL Results] view. Refresh the [Data Source Explorer] view to check the deleted table.