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.
See the
Screen Shot for
a visual look:
- Tables
- Columns
- Primary and Foreign Keys
- 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 MySQL table backup tool
- A MySQL table conversion tool for converting tables to other databases such as PostgreSQL, Oracle, MS SQL Server, SQLite, etc.
- A Search tool for searching for table data
- A compare tool for comparing tables and/or SQL query results
