Altova DatabaseSpy 2023 Enterprise Edition

You can drop either single tables or multiple tables in batch, as follows:

 

1.Do one of the following:

 

To drop a single table, right-click it in the Online Browser and select Drop Table from the context menu.

To drop multiple tables, right-click the "Tables" (or "User Tables", if applicable) folder, and select Drop tables from the context menu.

 

A change script is generated in the Database Structure Change Script Window, and the tables are marked for deletion, which is indicated by the dbs_ic_deleted_table icon. At this stage, you can still revert the changes by clicking the Refresh dbs_ic_refresh button in the Online Browser.

 

2.Click Execute Change Script dbs_ic_execute_script to commit the changes to the database.

 

See also Dropping Database Objects.

© 2017-2023 Altova GmbH