solidDB Database Query Tool and SQL Editor Features

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

solidDB GUI Tools

  • A solidDB 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 solidDB create view tool for creating solidDB views
  • A solidDB alter table tool for generating the SQL to alter solidDB tables.
  • SQL Drop Tools for dropping tables, views, etc.
  • A visual edit table tool for visually editing solidDB tables in a spreadsheet format
  • solidDB Import and Export tools for importing data into tables, or exporting data from single tables or all tables in a database

solidDB Database Browser

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