Summary of Features |
|
JDBA Tool has a wide variety of features that will enable you to effectively manage your database.
You can easily create table schema in a database and add columns to it. You can also define constraints for data in a table.
After creating the table schema and adding columns, you can insert records to a table. Moreover, you can define a constraint to ensure that each inserted record falls within a specified range.
You can define a column using a domain. The column inherits the properties of the domain (data type, default value, and value constraint) without requiring you to explicitly specify them.
After a table is created successfully, it is easy to create an index, primary key, or foreign key in a table. A foreign key lets you establish a relationship between different tables in a database.
DBMaker allows you to query easily by creating a view from various tables or specifying a synonym for a specific table. Views and synonyms let you refer to and manipulate data from tables quickly and easily.
After creating all database objects, you can easily drop a table, view, synonym, or domain. (To drop some objects, you should take into account the mutual relationships between objects. For example, you should drop a foreign key before dropping the referred primary key.)
Any authorized user can create database links to access database objects on remote databases
You can transfer table data between local and remote table objects through the Table Replication command.
To manage frequently used SQL commands, you can create stored commands which can be reused whenever needed.
To perform frequently repeated tasks easily, stored procedures are used. Thus, eliminating the need for repeated SQL compilation and optimization.
For handling complex transactions in the database, you can create triggers that will automatically execute when the user inserts, deletes, or updates data in the database.
A stored procedure can be called by a trigger action
Text indices can be created for columns with CHAR, VARCHAR, LONGVARCHAR and FILE data types.
As the system administrator, you can add users or groups to a database. After adding users and groups to a database, you can assign privileges to a user or a group. The benefit of a group is that you can assign the same privileges to multiple users. You only need to assign these privileges to a group once.
Monitor the current system environment such as which database users are currently connected to the database, locks placed on data objects, and all current runtime settings.
You can set default values for creating tables and choose to display BLOB data using SQL statements.