Using InterSystems SQL

Language Elements describes InterSystems SQL handling of literals, NULL, operators, and comments.

Implicit Joins (Arrow Syntax) provides an InterSystems SQL shorthand extension to perform a left outer join on a column specified in a SELECT clause.

Identifiers describes the conventions used for naming entities within InterSystems SQL.

Using Embedded SQL describes how to embedded InterSystems SQL code within ObjectScript code.

Using Dynamic SQL describes how to prepare and execute SQL code at runtime from ObjectScript code.

Using the SQL Shell Interface describes how to write and execute SQL statements from the InterSystems Terminal using a shell interface.

Using the Management Portal SQL Interface describes how to execute SQL statements and view and manage SQL features from the InterSystems Management Portal interface.

Defining Tables describes fundamental elements of tables (schema and table names, RowID and Primary Key), and how to define a table in InterSystems SQL, either by defining a persistent class or by using DDL commands.

Defining and Using Views describes how to define views and the view ID (%VID) in InterSystems SQL.

Relationships Between Tables describes how to define and maintain foreign keys and parent/child relationships in InterSystems SQL.

Using Triggers describes triggers that are automatically executed when a record is added, modified, or deleted in InterSystems SQL.

Collation describes collation types that specify how data values are ordered and compared in InterSystems SQL.

Modifying the Database describes how to insert, update, and delete data, and how to use transactions to group multiple data modifications.

Querying the Database describes how to create and execute queries in InterSystems SQL.

Defining and Using Stored Procedures describes how to define and use stored procedures in InterSystems SQL.

Storing and Using Stream Data (BLOBs and CLOBs) describes binary stream data and character stream data in InterSystems SQL.

SQL Users, Roles, and Privileges describes security features of InterSystems SQL, including defining users, associating users with roles, and assigning privileges to a user or a role.

SQL Settings Reference describes the mechanisms you can use to change various SQL settings.

Importing SQL Code describes how to import and execute SQL code from a text file, either InterSystems SQL or SQL code from other vendors.

Importing and Exporting SQL Data describes InterSystems SQL tools to import data from a text file to a table and to export data from a table to a text file.