5.1. DATABASE 5.1.1. CREATE DATABASE Using a Database Alias Creating a Database Remotely Optional Parameters for CREATE DATABASE Examples Using CREATE DATABASE 5.1.2. ALTE...

2.3. Identifiers 2.3.1. Rules for Regular Object Identifiers 2.3.2. Rules for Delimited Object Identifiers 2.3. Identifiers All database objects have names, often called iden...

10.1.2. COMMIT COMMIT Options 10.1.2. COMMIT Used for Committing a transaction Available DSQL, ESQL Syntax COMMIT [ WORK ] [ TRANSACTION tr_name ] [ RELEASE ] ...

5.15. ROLE 5.15.1. CREATE ROLE 5.15.2. ALTER ROLE 5.15.3. DROP ROLE 5.15. ROLE A role is a database object that packages a set of SQL privileges . Roles implement the c...

Chapter 8. Built-in Scalar Functions 8.1 Context Functions 8.1.1 RDB$GET_CONTEXT() 8.1.1.1 The SYSTEM Namespace 8.1.1.2 The DDL_TRIGGER Namespace 8.1.1.3 Examples 8.1.2 RDB...

7.6 Triggers 7.6.1 Firing Order (Order of Execution) 7.6.2 DML Triggers 7.6.2.1 Trigger Options 7.6.2.2 OLD and NEW Context Variables 7.6.3 Database Triggers 7.6.4 DDL Trigg...

6.6 MERGE 6.6.1 The RETURNING Clause 6.6.2 Examples of MERGE 6.6 MERGE Used forMerging data from a source set into a target relation Available inDSQL, PSQL Syntax MERG...

NULL Handling in SQLite Versus Other Database Engines NULL Handling in SQLite Versus Other Database Engines The goal is to make SQLite handle NULLs in a standards-compliant way...

4.2 Predicates 4.2.1 Conditions 4.2.2 Comparison Predicates 4.2.2.1 Other Comparison Predicates 4.2.2.1.1 BETWEEN 4.2.2.1.2 LIKE 4.2.2.1.2.1 Wildcards 4.2.2.1.2.2 Using the E...

Chapter 10. Window (Analytical) Functions 10.1 Aggregate Functions as Window Functions Chapter 10. Window (Analytical) Functions According to the SQL specification, window func...