Displays a list of Tables/Views/Functions/Procedures/Triggers on the left and detailed information about Columns on the right
Real-time registration of Table/View/Function/Procedure Column Comments
Management of detailed information registration for Table/View/Function/Procedure/Trigger (developer handovers/comments, etc.)
Real-time registration of ColumnID's Logical Name, ability to change ColumnID, and adjust Column length
Ability to change and add default values
View and modify creation scripts for Table/View/Function/Procedure/Trigger
Ability to copy Column information and paste it into Excel
Automatic generation of Object (Table/View/Function/Procedure/Trigger) Creation Script
Auto-input feature for column comments (automatically inserts the most frequently used column comment from previous uses)
View All Tables and Columns
Displays all Table and Column information together
Ability to register and modify Column Logical Names, and filter search by Column and Table names
Capability to export all content to Excel
Automatically displays selected Table information when moving to the selected Table Column view or Data view screen
SQL Editor
Supports up to 15 editing windows
SQL syntax highlighting
Ability to save and load all SQL statements in editing windows collectively (Workspace feature)
Individual save and load capability for SQL statements in each editing window
Automatic typing of Table or Column names from the Column View at the bottom of the screen into the SQL editing window
Displays execution results in Grid or Text format
Displays header sequence numbers in execution results, facilitating data handling during development (e.g., RS(0), RS(3))
Generates header for MS Flexgrid or VS Flexgrid and source code for adjusting Column width
Ability to convert or reverse-convert queries in the SQL editing window into VB, C#, or ASP Code
Supports multiple queries in a single SQL editing window (results can be viewed by moving through a small scroll bar in the center right)
Customizable font properties and colors in the editing windows through settings to suit user preferences
Capability to view cost plan for tuning query results
SQL statement printing feature
Database Information
Database size
Supported data types
Database information
Tablespace information
Supported languages
User connection status: detailed information, Last Query view, and ability to Kill
Lock status: detailed lock information and Last Query view, ability to Kill
Active transactions: displays all currently ongoing transactions that have not been rolled back or committed
Log space analysis and cleanup: displays log usage for all databases and allows cleanup
View used Tables analysis: displays Tables and Columns used by Views
Agent Job List: displays Job content, schedule, history, and forced execution of failed Jobs
Data View
Displays a list of Tables/Views on the left and the actual data of Tables/Views on the right
Possible to add, modify, and delete data; generates data insertion script (INSERT INTO...)
Capable of Data Filtering searches and Data Sorting features
Data can be exported to or imported from Excel
Ability to toggle header view between Physical Name and Logical Name
Ability to copy Tables (including Data) between servers
Reports
Generates report information in Excel (compatible with all versions of Excel from MS Office 97 to the present)
Generates list information (list of all objects/Tables/Views/Functions/Procedures/Triggers)
Generates detailed specifications (Specifications for Table/View/Function/Procedure/Trigger, with creation scripts for View/Function/Procedure/Trigger included in the Excel document)
Allows customization of the report template according to user preferences through report settings
Batch Data Modification
Displays all Tables and Columns containing the data being searched, along with the count of data entries
Capable of batch updates
Data Change Tracking
Save DB: Saves the current state of the database
Check DB: Analyzes and reports the change status of all Table Data altered since the last Save DB
Displays detailed information about added, deleted, or changed Rows and Columns, including previous and changed values
Useful for analyzing undisclosed source programs and for program verification during development
Smart Factory Solutions
Upgrade your factory with solutions optimized for the factory environment.