create, alter and drop database objects such as tables, indexes, tablespaces, functions, stored procedures.
run various admin actions against your objects (such as Rename, Runstats, Analyze)
generate full DDL for your objects (not just tables, but also tablespaces, triggers, procedures, etc).
manage security for your objects with the comprehensive security helper
As elsewhere in AQT, the Admin Component is driven entirely from configuration files. These define the structure of your database objects, and the actions that can be performed on them. This design has allowed us to configure the Admin Component for a large number of database types, and it allows you to define your own admin functions for any particular requirements.
The Admin component has been configured for Oracle, DB2 for LUW, DB2 for z/OS, DB2 for iSeries, Sybase ASE, Sybase Anywhere, Sybase IQ, SQL Server, MySQL, Informix, Pervasive.SQL, PostgreSQL, MS Access, SQLite, Ingres and SQLBase.
This is an example of Create Table window for DB2 for LUW.
AQT makes it very easy to alter a table, as demonstrated by the following example:
as you make changes, they are highlighted in yellow.
clicking on Preview will show you the SQL which AQT will run to alter the table
clicking on Run will apply the changes. If any of the changes fail, the values will remain highlighted in yellow for you to correct or cancel.
Define other Objects
You can define a lot more than just tables. This screenshot shows creation of a foreign key.
Creating a Stored Procedure
AQT is also able to create and alter Stored Procedures. Plus Triggers, Functions.
Actions Against Objects
You can run various actions against multiple objects. This example will change the comments of your tables. Many other functions have been defined.
AQT has a comprehensive DDL Generator
Tables DDL can include primary key, indexes, foreign keys, check-constraints, triggers, dependent views and aliases, grant statements.
AQT generates well-formatted and readable DDL.
AQT can also generate DDL for other objects, such as tablespaces, bufferpools, stored procedures, functions.
You can generate the DDL for all objects in a schema in a single action.
You can generate the DDL to the window, or to a file, or to a separate file for each object.
You can generate DDL for another database type. For instance, you can generate DB2 for LUW using Oracle syntax. This is useful if you are migrating objects between different database types.