Informix DBA Survival Guide, Second Edition

Table Editor

The Table Editor application provides a graphical method of creating, inspecting, and modifying table structures in Informix databases. When the utility is first entered, the user chooses a server, then a database on that server, and finally a table within that database. This choice of server/database/table can also be made directly from the toolbar or from the menu using the Table→Open menu choice or the Open Folder toolbar button.

The Table Editor has three main tabbed pages, Columns, Indexes, and Foreign Keys. Much of the useful information is in the Columns tab. From the Table→Properties menu, the user sees a screen listing several items of interest regarding the table. The Status tab shows name, owner, modification date, row ...