Sybase IQ Database Query Tool and SQL Editor Features

RazorSQL contains support for the following Sybase versions: Sybase IQ, Sybase Adaptive Server Enterprise, and Sybase SQL Anywhere.

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

Sybase IQ GUI Tools

  • A Sybase IQ create table tool that generates Sybase IQ specific create table SQL that includes such elements as column names, column types, column lengths or precisions, column scales, nullability, unique constraints, identity, and default values
  • A Sybase IQ create view tool that generates the SQL for creating Sybase IQ views
  • A Sybase IQ create index tool that generates the SQL for creating Sybase IQ indexes and includes elements such as index name, uniqueness, and columns
  • Tools for creating Sybase IQ procedures
  • A Sybase IQ alter table tool for generating the SQL to alter Sybase IQ tables.
  • SQL Drop Tools for dropping tables, views, etc.
  • A visual edit table tool for visually editing Sybase IQ tables in a spreadsheet format
  • Sybase IQ Import and Export tools for importing data into tables, or exporting data from single tables or all tables in a database
  • A Generate DDL Tool for Sybase IQ for generating Sybase IQ DDL.

Sybase IQ Database Browser

  • Displays information in a tree format for databases, tables, views, indexes, and procedures
  • Displays Sybase IQ 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