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 if you have any particular requirements.
Create Table
This is an example of Create Table window for DB2 for LUW.
Creating a Table
Alter Table
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.
Altering a Table
Define other Objects
You can define a lot more than just tables. This screenshot shows creation of a foreign key.
Creating a Foreign Key Relationship
Creating a Stored Procedure
AQT is also able to create and alter Stored Procedures. Plus Triggers, Functions.
Creating a Stored Procedure
Actions Against Objects
You can run various actions against multiple objects. This example will change the comments of your tables. Numerous other functions have been defined, such as Drop Table, Rename Table, Rename Columns, Reset Check-Pending, Disable Triggers, Runstats,
Commenting multiple tables on a single window
Generate DDL
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.
