Schema Manager

Use these pages to review and manage database objects and table objects, including databases, tables, indexes, and data marts.

Actions

Create Database: Create a database and specify the locale for the database. For this action, the OpenAdmin Tool (OAT) for Informix® requires IBM® Informix 11.70.xC2 or later.
Create Demo Database: Create the demo database, which contains a relational schema and sample data for a fictitious business.
Drop Database: Remove a database and delete the tables and data stored in it. For this action, OAT requires Informix 11.70.xC2 or later.
Add all Tables to a Grid Table List: Add all the tables in the selected database to a grid table list for a specific grid. Tables in a grid table list must have the same column names and attributes and can be used in grid queries. Grid queries run on each server in a region or a grid and the results are consolidated. This action also restricts ALTER actions on the tables to the context of the grid. This action requires Informix 12.10.
Remove all Tables from a Grid Table List: Remove all the tables in the selected database from a grid table list. Tables in the database will no longer be able to participate in grid queries for the grid. This action requires Informix 12.10.
Create Table: Create a table in the selected database, and define the attributes necessary to make the table fully functional.
Drop Table: Remove a table and delete the data stored in it, or remove a synonym or view.
Truncate Table: Delete all rows from a table and free the associated storage space. You can reserve the storage space for reuse by the table and its indexes.
Load Table: Load data into a database table from an external source. For this action, OAT requires Informix 11.50.xC6 or later.
Unload Table: Unload data from a database table to an external table. For this action, OAT requires Informix 11.50.xC6 or later.
Add to a Grid Table List: Add the table to a grid table list for a specific grid. Tables in a grid table list must have the same column names and attributes and can be used in grid queries. Grid queries run on each server in a region or a grid and the results are consolidated. This action also restricts ALTER actions on the table to the context of the grid. This action requires Informix 12.10.
Remove from a Grid Table List: Remove the table from the grid list. The table will no longer be able to participate in grid queries for the grid. This action requires Informix 12.10.
Create Index: Create an index on a table.
Data Marts: For these actions, OAT requires Informix 12.10.