SQLite Database Query Tool Features

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

SQLite Visual Tools

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

SQLite Database Browser

  • Displays information in a tree format for databases, tables, views, triggers, and indexes
  • An SQLite View DDL option for viewing object DDL such as the Create Table DDL behind SQLite tables
  • Displays SQLite 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