Specifications

CHAPTER 3 Managing the Database
Users Guide 93
Dropping a table
Dropping removes the table from the database.
❖ To drop a table:
1 Select Drop Table from the table’s pop-up menu or select Object>Delete
from the menu bar.
2 Click Yes.
Deleting orphaned
table information
If you drop a table outside InfoMaker, information remains in the system tables
about the table, including extended attributes for the columns.
❖ To delete orphaned table information from the extended attribute system
tables:
• Select Design>Synch Extended Attributes from the menu bar and click
Yes.
If you try to delete orphaned table information and there is none, a
message tells you that synchronization is not necessary.
Viewing pending SQL changes
As you create or alter a table definition, you can view the pending SQL syntax
changes that will be made when you save the table definition.
❖ To view pending SQL syntax changes:
• Right-click the table definition in the Columns view and select Pending
Syntax from the pop-up menu.
InfoMaker displays the pending changes to the table definition in SQL
syntax:
The SQL statements execute only when you save the table definition or
reset the view and then tell InfoMaker to save changes.