SQL Engine Reference - Contents
Who Should Read this Manual
Manual Organization
Conventions
For More Information
Data Definition Statements
Creating, Modifying, and Deleting Tables
Creating and Deleting Indexes
Creating and Deleting Triggers
Creating and Deleting Stored Procedures
Data Manipulation Statements
Retrieving Data
Modifying Data
Defining Transactions
Creating and Deleting Views
Executing Stored Procedures
Executing Triggers
Data Control Statements
Enabling and Disabling Security
Creating and Deleting Users and Groups
Granting and Revoking Rights
Database Names
Pervasive ODBC Engine Interface Limits
Data Source Name Connection String Keywords
ODBC API Conformance
Exceptions to ODBC API Conformance
SQL Grammar Conformance
Delimited Identifiers in SQL Statements
Grammar Statements
ADD
ALL
ALTER TABLE
ANY
AS
BEGIN [ATOMIC]
CALL
CASCADE
CASE
CLOSE
COMMIT
CREATE GROUP
CREATE INDEX
CREATE PROCEDURE
CREATE TABLE
CREATE TRIGGER
CREATE VIEW
DECLARE
DECLARE CURSOR
DELETE (positioned)
DELETE
DISTINCT
DROP GROUP
DROP INDEX
DROP PROCEDURE
DROP TABLE
DROP TRIGGER
DROP VIEW
END
EXISTS
FETCH
FOREIGN KEY
GRANT
GROUP BY
HAVING
IF
IN
INSERT
JOIN
LEAVE
LIKE
LOOP
NOT
OPEN
PRIMARY KEY
PUBLIC
PRINT
RELEASE SAVEPOINT
RESTRICT
REVOKE
ROLLBACK
SAVEPOINT
SELECT (with into)
SELECT
SET DECIMALSEPARATORCOMMA
SET OWNER
SET PASSWORD
SET ROWCOUNT
SET SECURITY
SET TIME ZONE
SET TRUENULLCREATE
SET VARIABLE
SIGNAL
SQLSTATE
START TRANSACTION
UNION
UNIQUE
UPDATE
UPDATE (positioned)
USER
WHILE
Grammar Element Definitions
Scalar Functions
Global Variables
Other Characteristics
Temporary Files
Working with Literal Values
Working with Binary Data
Creating Indexes
Closing an Open Table
Concurrency
Comma as Decimal Separator
OEM to ANSI Support
Optimizations at a Glance
Restriction Analysis
Modified CNF Conversion
Restrictions that Cannot be Converted
Conditions Under Which Conversion is Avoided
Restriction Optimization
Single Predicate Optimization
Closed Range Optimization
Modified Disjunct Optimization
Conjunct Optimization
Disjunctive Normal Form Optimization
Modified Conjunctive Normal Form Optimization
Closing Open Ended Ranges through Modified CNF Optimization
Single Join Condition Optimization
Conjunct with Join Conditions Optimization
Modified Conjunctive Normal Form with Join Conditions Optimization
Closing Join Condition Open Ended Ranges through Modified CNF Optimization
Multi-Index Modified Disjunct Optimization
Push-Down Filters
Past Behavior
Efficient Use of Indexes
DISTINCT in Aggregate Functions
DISTINCT Preceding Selection-list
Relaxed Index Segment Order Sensitivity
Relaxed Segment Ascending Attribute Sensitivity
Search Update Optimization
Temporary Table Performance
Row Pre-fetch
Terminology
Pervasive.SQL Supported Data Types
Data Type Ranges
Notes on Data Types
CHAR, VARCHAR, and LONGVARCHAR
BINARY and LONGVARBINARY
Limitations on LONGVARCHAR and LONGVARBINARY
Comparison of Floats
Representation of Infinity
Legacy Data Types
Btrieve Key Data Types
Reserved Words
Words to Avoid
Installing System Tables and Data Dictionary Files
X$File
X$Field
X$Index
X$Attrib
X$View
X$Proc
X$User
X$Rights
X$Relate
X$Trigger
X$Depend
