MariaDB SQL Editor
RazorSQL includes a MariaDB SQL editor that has features designed to boost productivity such as auto completion / intellisense for tables and columns, multi-tabular display of query results, SQL and DDL execution, and the ability to create, edit, and drop procedures, functions, triggers, and other database objects. It includes MariaDB specific syntax highlighting for SQL and supports over 20 other programming languages such as PHP, Python, JavaScript, HTML, and Java. Listed below are the main features of the MariaDB SQL Editor in RazorSQL.
MariaDB SQL Editor Features
- Multi-Tabular Display of Query Results
- The ability to display multiple query result sets in the same tab
- SQL generation capabilities such as the ability to auto-generate SQL select, insert, update, and delete statements.
- The ability to create new tables from queries
- MariaDB specific syntax highlighting
- Auto table lookup and completion
- Auto column lookup and completion
- Extensive find, replace, and find / replace in files functionality
- Bracket, parenthesis, and brace auto matching
- Support for parameterized queries
- SQL Formatter
- Execute, Execute Fetch All, and Execute Batch functions
- Sortable Query Results
- Filterable Query Results
- Searchable Query Results
- SQL History for All Queries, and Query Logging Per Connection
- Query browser for displaying a clickable display of queries in the editor
- Key Ahead functionality for one-click population of user-defined text
- Built-in and Custom User Templates
