OpenBase Database Query Tool Features

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

OpenBase Visual Tools

  • An OpenBase create table tool that generates OpenBase 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
  • An OpenBase create view tool that generates the SQL for creating OpenBase views
  • An OpenBase create index tool that generates the SQL for creating OpenBase indexes and includes elements such as index name, uniqueness, and columns
  • An OpenBase alter table tool for generating the SQL to alter OpenBase tables with such options as add column, add primary key, add foreign key, add constraint, drop column, drop constraint, and rename column
  • SQL Drop Tools for dropping tables and views
  • A visual edit table tool for visually editing OpenBase tables in a spreadsheet format
  • OpenBase Import and Export tools for importing data into tables, or exporting data from single tables or all tables in a database

OpenBase Database Browser

  • Displays information in a tree format for databases, tables, system tables, procedures, triggers, and users
  • Displays OpenBase 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