Local SQL BDE documentation

- - -

- (minus)

- * -

* (multiply)

- / -

/ (divide)

- | -

|| (concatenation function)

- + -

+ (plus)

	Arithmetic list
	Concatenation using plus (+)

- A -

aggregate functions

	GROUP BY clause
	HAVING clause
	AVG function
	COUNT function
	MAX function
	MIN function
	SUM function

ALL predicate

ALTER TABLE statement

AND

	Operators list
	Logical operators

ANY predicate

arithmetic operators

	Operators list
	Arithmetic list

- B -

Borland Database Engine

- C -

	LOWER function
	UPPER function

case-insensitive comparisons

case-insensitive filtering

CAST function

century in dates

changing table structures

clauses

	Clause list
	FROM clause
	WHERE clause
	ORDER BY clause
	GROUP BY clause
	HAVING clause

client-based SQL

column correlation names

	Column correlation names
	Column correlation names w. spaces

column names

column types

columns

	Column correlation names
	IS NULL predicate

	Statement list
	DDL statement overview

comments

comparing against multiple values

	BETWEEN predicate
	IN predicate

Comparison predicates

Comparisons and NULLs

concatenation

Concatenation function

	Concatenation function
	Concatenation using plus (+)

conditions

	WHERE clause
	Predicate list
	Comparison predicates
	BETWEEN predicate
	EXISTS predicate
	IN predicate
	LIKE predicate
	IS NULL predicate
	SOME / ANY / ALL predicates

constraints

conventions

	Conventions
	Table names
	Column names
	Date formats
	Time formats
	Boolean literals
	Table correlation names
	Column correlation names
	Embedded comments
	Reserved words
	Unsupported language

converting data types

correlation names

	Table correlation names
	Column correlation names
	Column correlation names w. spaces

COUNT function

counting rows

CREATE INDEX statement

CREATE TABLE statement

	Native table column names
	SQL data types
	CREATE TABLE statement

- D -

	DELETE statement
	INSERT statement
	UPDATE statement

adding

deleting

updating

Data Definition Language

Data Manipulation Language

data types

	Native table column names
	SQL data types

datatypes

	DDL statement overview
	CREATE TABLE statement
	ALTER TABLE statement
	DROP TABLE statement
	CREATE INDEX statement
	DROP INDEX statement

defining column types

	Operators list
	Arithmetic list

DML statements

	DML statement overview
	Statement list
	SELECT statement
	DELETE statement
	INSERT statement
	UPDATE statement

- E -

- F -

	WHERE clause
	HAVING clause
	Predicate list
	Comparison predicates
	BETWEEN predicate
	EXISTS predicate
	IN predicate
	LIKE predicate
	IS NULL predicate
	SOME / ANY / ALL predicates

Foreign columns in UPDATE

FRACTIONAL_PART

FROM clause

functions

	Function list
	Concatenation function
	LOWER function
	UPPER function
	SUBSTRING function
	TRIM function
	COUNT function
	MAX function
	MIN function
	SUM function
	CAST function
	EXTRACT function
	Concatenation using plus (+)

- G -

- H -

- I -

	CREATE TABLE statement
	CREATE INDEX statement
	DROP INDEX statement

- J -

	Relational operators list
	Equi-join
	INNER join
	OUTER join
	Cartesian join
	UNION join
	Heterogenous join
	Updatable queries

- L -

	Operators list
	Logical operators

- M -

	Operators list
	Arithmetic list

modifying table structures

MODULUS

multiply

	Operators list
	Arithmetic list

- N -

naming conventions

native column types

NOT

	Operators list
	Logical operators

NULL in comparisons

- O -

operators

	Operators list
	Arithmetic list

	Operators list
	Logical operators

ORDER BY clause

OUTER join

- P -

Parameter substitutions

partial-string filtering

plus

	Operators list
	Arithmetic list

predicates

	Predicate list
	Comparison predicates
	BETWEEN predicate
	EXISTS predicate
	IN predicate
	LIKE predicate
	IS NULL predicate
	SOME / ANY / ALL predicates

primary indexes

	Updatable queries
	CREATE TABLE statement
	DROP INDEX statement

- Q -

QBE files

queries

multi-table

	Relational operators list
	Equi-join
	INNER join
	OUTER join
	Cartesian join
	UNION join
	Heterogenous join
	Updatable queries

- R -

ranges

read-only queries

relational operators

	Relational operators list
	Equi-join
	INNER join
	OUTER join
	Cartesian join
	UNION join
	Heterogenous join
	Updatable queries

remarks

reserved words

restrictions

	Reserved words
	Unsupported language
	Updatable queries

- S -

	Updatable queries
	CREATE INDEX statement
	DROP INDEX statement

	Statement list
	DELETE statement
	INSERT statement
	UPDATE statement
	DDL statement overview
	CREATE TABLE statement
	ALTER TABLE statement
	DROP TABLE statement
	CREATE INDEX statement
	DROP INDEX statement