Netezza Database Query Tool and SQL Editor Features

RazorSQL contains a Netezza database query tool, SQL editor, and database browser. It also includes GUI tools for Netezza administration tasks. Listed below are more details on these features.

Netezza Database Browser

  • Displays information in a tree format for databases, tables, views, etc.
  • Displays Netezza 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

Netezza GUI Tools

  • A Netezza create table tool that generates Netezza specific create table SQL that includes such elements as column names, column types, column lengths or precisions, column scales, nullability, unique constraints, and default values
  • A Netezza alter table tool for generating the SQL to alter Netezza tables.
  • SQL Drop Tools for dropping tables, views, etc.
  • A visual edit table tool for visually editing Netezza tables in a spreadsheet format
  • Netezza Import and Export tools for importing data into tables, or exporting data from single tables or all tables in a database