SQL Development

This section provides information to help you program with SQL.

Note: For a given transaction engine, execution of a DDL operation blocks execution of any other DDL operation until execution of the first DDL operation is complete. The transaction engine can execute DML operations concurrently with a DDL operation.

The following SQL reference information is also available:

See the following topics:

Rules for Specifying NuoDB Identifier Names

Working with Transactions

About Join Operations Supported by NuoDB

Controlling the Flow of Execution

SQL Procedures, Functions, and Triggers

Using Updatable Views

Using SQL Trace Facility

Investigating Hung Queries

Understanding EXPLAIN Command Output

Improving Query Performance

Using NuoDB SQL Explorer

Using NuoDB SQL Command Line

Internationalization and Localization