MySQL Database Browser
The MySQL Database Browser included in RazorSQL allows users to browse database objects and structures. It displays information about the following types of objects for MySQL versions 5 or newer. Older versions of MySQL include a subset of these objects:
- Tables
- Views
- Procedures
- Functions
- Triggers
- Indexes
- Constraints
- Users
The MySQL Browser also includes tools for interacting with the above objects such as the following:
- Tools for viewing the contents of objects such as tables, views, and system tables
- A describe table and view tool
- Tools for editing procedures, functions, and triggers
- Tools for viewing system information about objects
- Tools for creating tables, views, indexes, procedures, functions, triggers, databases, and users
- Tools for altering tables and views
- Tools for dropping tables, views, procedures, functions, triggers, databases, and users
- Tools for editing tables, procedures, functions, and triggers
- A truncate table tool
- A tool to generate DDL (data definition language) of tables
- Tools for importing and exporting data
- An SQL query builder
- A compare tool for comparing tables and/or SQL query results