RazorSQL contains a SQL editor that includes syntax highlighting and function lookup for many languages such as SQL, PL/SQL for Oracle, Transact-SQL for SQL Server and Sybase, SQL PL for DB2, and support for other popular programming languages like PHP, Java, JavaScript, HTML, CSS, XML, and many more.
The SQL editor also supports auto completion and auto lookup. For example, when typing an SQL select query in the SQL editor, after typing a keyword such as where, the editor will perform on auto column lookup to display the list of available columns pertaining to the current query. After typing a keyword such as from, the SQL editor will display a list of available tables to choose from.
The SQL editor also allows users to execute multiple queries at a time using the execute all option, or to execute only queries based on the current cursor position assuming queries are separated by semi-colons. Users can also manually highlight queries they wish to execute.
- SQL; Windows 10; Products & Services. Windows Server; Enterprise Mobility + Security. I downloaded the enterprise version of the visual studio for mac and login as my enterprise account. In Visual Studio for Mac editor visual studio for mac macos 10.14 Fixed - Pending Release. Lluis Sanchez Gual [MSFT] commented 2 days ago.
- This has changed over time, with a big highlight in April 2015 when Microsoft launched Visual Studio Code, its cross-platform code editor, for Windows, Mac, and Linux.
Visual Studio dev tools & services make app development easy for any platform & language. Try our Mac & Windows code editor, IDE, or VSTS for free.
The SQL editor displays query results in a tabular format. Each query gets its own tab. The query results section includes many features such as one-click editing of data, data searching, filter and sort tools, and data import and export tools.
The editor tries to determine the syntax highlighting type based on the type of file and / or the type of database connection. For example, if the file ends in .xml, RazorSQL will display XML syntax highlighting unless the user changes the highlighting type manually.
Normally the default syntax highlighting type is the SQL type. However, if connected to Oracle, SQL Server, Sybase, or DB2, the editor will set the highlighting type to that particular database's programming language, i.e., PL/SQL for Oracle, TSQL for SQL Server and Sybase, and SQL PL for DB2.
The SQL Editor will also display custom sytnax highlighting for MySQL and PostgreSQL keywords.
Listed below are links to more specific information about some of the SQL editors provided by RazorSQL:
DB2 SQL Editor
Derby SQL Editor
DynamoDB SQL Editor
Firebird SQL Editor
FrontBase SQL Editor
H2 SQL Editor
HSQLDB SQL Editor
Informix SQL Editor
Ingres SQL Editor
Interbase SQL Editor
InterSystems Cache SQL Editor
MongoDB SQL Editor
MS Access SQL Editor
MS SQL Server SQL Editor
MySQL SQL Editor
OpenBase SQL Editor
Oracle SQL Editor
Pervasive SQL Editor
PostgreSQL SQL Editor
Salesforce SQL Editor
SimpleDB SQL Editor
SQL Azure SQL Editor
SQLite SQL Editor
SQL Anywhere SQL Editor
Sybase SQL Editor
Teradata SQL Editor
The RazorSQL Apache Cassandra database client and query tool includes a Cassandra database browser, SQL editor, table editor, Cassandra import and export tools, Cassandra backup tools, and other custom Cassandra GUI tools. Listed below are more details on these features.
Execute SQL select, insert, update, and delete statements against Cassandra tables. The SQL editor includes auto column lookup, and support for over 20 programming languages such as SQL, PHP, HTML, XML, Java, and more.
Browse the details of a Cassandra database cluster including schemas, tables, materialized views, columns, and key information. Easily edit, describe, backup, query tables, create tables, and compare tables or query results with the click of the mouse.
Cassandra GUI Tools
- A GUI Cassandra create table tool that generates Cassandra specific create table SQL that includes such elements as column names, column types, primary key, and identity data.
- A GUI Cassandra create keyspace / schema tool that generates Cassandra create keyspace / schema statements using replication class, replication center, data center information, etc.
The Cassandra export tool in RazorSQL allows users to export data from Cassandra in various formats such as delimited files, Excel spreadsheets, SQL insert statements, HTML, XML, and text.
The Cassandra import tool in RazorSQL allows users to import data into the Cassandra database from Excel files, delimited files, fixed-width files and files containing SQL statements.
Cassandra Table Editor
The Cassandra table editor allows users to edit Cassandra data in a spreadsheet like format. Users can edit individual cells, delete rows, copy rows, and update, insert, or delete data. The table editor automatically generates the appropriate SQL insert, update, or delete statements to be executed.
Sql Editor Download
Cassandra Backup Tools
Photo Editor For Mac
Backup individual tables or all tables in a database/schema with the RazorSQL Cassandra backup tools. The tools generate SQL DDL and SQL insert statements for all tables and data in the database.