Informix Database Query Tool Features

The Informix database query tool features provided by RazorSQL include a custom database browser tailored to Informix, an SQL editor with Informix specific features and syntax highlighting, custom Informix visual tools, and Informix specific database administration tools. Listed below are more details on these features.

Informix Visual Tools

  • An Informix create table tool that generates Informix specific create table SQL that includes such elements as column names, column types, column lengths or precisions, column scales, nullability, unique constraints, default values, and the ability to add check constraints.
  • An Informix create view tool that generates the SQL for creating Informix views
  • An Informix create index tool that generates the SQL for creating Informix indexes and includes elements such as index name, uniqueness, and columns
  • An Informix create sequence tools that generates the SQL for creating Informix sequences
  • An Informix create procedure tool for generating the SQL to create Informix procedures
  • An Informix create function tool for generating the SQL to create Informix functions
  • An Informix create trigger tool for generating the SQL to create Informix triggers
  • An Informix alter table tool for generating the SQL to alter Informix tables with such options as add column, add primary key, add foreign key, add constraint, drop column, and drop constraint
  • An Informix alter view tool for generating the SQL to alter Informix views
  • SQL Drop Tools for dropping tables, views, indexes, procedures, functions, and triggers for Informix
  • A visual edit table tool for visually editing Informix tables in a spreadsheet format
  • Tools for editing functions, procedures, and triggers for Informix.
  • Informix Import and Export tools for importing data into tables, or exporting data from single tables or all tables in a database

Informix Database Browser

  • Displays information in a tree format for databases, tables, views, procedures, functions, triggers, indexes, and users
  • Displays Informix table information such as column name, column type, column length, column nullability, and primary and foreign key information
  • Easily view table contents or database object information via the View Contents and Show Info context menu options