Глоссарий

О сайте

Источники и Авторы

Соглашения синтаксиса

Разновидности языка SQL

Типы данных

Обработка ошибок

Ошибки при создании метаданных

Математические операции с датой и временем

Системные таблицы

Таблицы мониторинга

Встроенные функции

Операторы конструкции SELECT

ABS()

ACOS()

ACTION

ADDMILLISECOND()

ADDSECOND()

ADDMINUTE()

ADDDAY()

ADDWEEK()

ADDMONTH()

ADDYEAR()

ALTER CHARACTER SET

ALTER DATABASE

ALTER DOMAIN

ALTER EXCEPTION

ALTER EXTERNAL FUNCTION

ALTER INDEX

ALTER PROCEDURE

ALTER SEQUENCE

ALTER TABLE

ALTER TRIGGER

ALTER USER

ASCII_CHAR()

ASCII_VAL()

ASIN()

ATAN()

ATAN2()

AUTONOMOUS TRANSACTION

AVG()

BACKUP

BASENAME

BIGINT

BIN_AND()

BIN_OR()

BIN_SHL()

BIN_SHR()

BIN_XOR()

BIT_LENGTH()

BLOB

BLOCK

BOTH

BREAK

CACHE

CASCADE

CASE

CAST()

CEIL()

CEILING()

CHAR

CHAR VARYING

CHAR_LENGTH

CHAR_TO_UUID()

CHARACTER

CHARACTER VARYING

CHARACTER_LENGTH

CHECK

CHECK_POINT_LEN

CLOSE

COALESCE

COLLATION

COMMENT

COMMIT

CONNECT

CONTAINING

CONSTRAINT

COS()

COSH()

COT()

COUNT()

CREATE DATABASE

CREATE DOMAIN

CREATE EXCEPTION

CREATE GENERATOR

CREATE INDEX

CREATE PROCEDURE

CREATE ROLE

CREATE SEQUENCE

CREATE SHADOW

CREATE TABLE

CREATE TRIGGER

CREATE USER

CREATE VIEW

CROSS

CURRENT_CONNECTION

CURRENT_DATE

CURRENT_ROLE

CURRENT_TIME

CURRENT_TIMESTAMP

CURRENT_TRANSACTION

CURRENT_USER

CURSOR

DATE

DAY

DAY OF WEEK

DECIMAL(n,m)

DECLARE CURSOR

DECLARE CURSOR (BLOB)

DECLARE EXTERNAL FUNCTION

DECLARE FILTER

DECLARE STATEMENT

DECLARE TABLE

DELETE

DELETING

DESCRIBE

DESCRIPTOR

DIFFERENCE

DISCONNECT

DIV()

DOUBLE PRECISION

DOW()

DROP DATABASE

DROP DOMAIN

DROP EXCEPTION

DROP EXTERNAL FUNCTION

DROP FILTER

DROP GENERATOR

DROP INDEX

DROP PROCEDURE

DROP ROLE

DROP SHADOW

DROP TABLE

DROP TRIGGER

DROP USER

DROP VIEW

DSQL

EXCEPTION

EXECUTE BLOCK

EXECUTE PROCEDURE

EXECUTE STATEMENT

EXISTS

EXIT

EXTERNAL

EXTRACT()

.fdb

FETCH

FETCH(BLOB)

FIRST

FLOAT

FOR

FOREIGN KEY

FREE_IT

FROM

.GDB

.GDBA

gbak

GDSCODE

GEN_ID()

GEN_UUID()

GRANT

GROUP_COMMIT_WAIT

GROUP BY

HAVING

HASH()

HOUR

.ib

instclient.exe

isql.exe

IF

IIF()

INDEX

INSERT

INSERTING, UPDATING, DELETING

INT64

INTEGER

IN AUTONOMOUS TRANSACTION

LAST

LEADING

LEAVE

LEFT()

LIKE

LIST

LOCK

LOG_BUF_SIZE

LOGFILE

LOWER()

MAX()

MIN()

MINUTE

MONTH

MON$ATTACHMENTS

MON$CALL_STACK

MON$CONTEXT

MON$CONTEXT_VARIABLES

MON$DATABASE

MON$IO_STATS

MON$METADATA

MON$MEMORY_USAGE

MON$RECORD_STATS

MON$STATEMENTS

MON$TRANSACTIONS

NATIONAL CHAR(n)

NATIONAL CHARACTER(n)

NCHAR(n)

NEW, OLD

NEXT

NEXT VALUE FOR

NO ACTION

NULLIF

NULLS

NUM_LOG_BUFS

NUMERIC(n,m)

OCTET_LENGTH

OLD

OPEN

ORDER BY

overlay

PI()

PLAN

POSITION()

POWER()

PRIMARY KEY

PROCEDURE

PSQL

RAND()

RAW_PARTITIONS

RDB$ADMIN

RDB$BACKUP_HISTORY

RDB$CHARACTER_SETS

RDB$CHECK_CONSTRAINTS

RDB$COLLATIONS

RDB$DATABASE

RDB$DEPENDENCIES

RDB$EXCEPTIONS

RDB$FIELDS

RDB$FIELD_DIMENSIONS

RDB$FILES

RDB$FILTERS

RDB$FORMATS

RDB$FUNCTIONS

RDB$FUNCTION_ARGUMENTS

RDB$GENERATORS

RDB$INDEX_SEGMENTS

RDB$INDICES

RDB$LOG_FILES

RDB$PAGES

RDB$PROCEDURES

RDB$PROCEDURE_PARAMETERS

RDB$REF_CONSTRAINTS

RDB$RELATIONS

RDB$RELATION_CONSTRAINTS

RDB$RELATION_FIELDS

RDB$ROLES

RDB$SECURITY_CLASSES

RDB$TRANSACTIONS

RDB$TRIGGERS

RDB$TRIGGER_MESSAGES

RDB$TYPES

RDB$USER_PRIVILEGES

RDB$VIEW_RELATIONS

RDB$GET_CONTEXT()

RDB$SET_CONTEXT()

RECREATE

RECREATE EXCEPTION

RECREATE TRIGGER

RELEASE

REPLACE()

RESTART

RESTRICT

RETURNS

RETURNING

REVERSE()

REVOKE

ROLE

ROLLBACK

ROW_COUNT

ROWS

SAVEPOINT

SCALAR_ARRAY

SECOND

SELECT

SEQUENCE

SET DEFAULT

SET GENERATOR

SET NULL

SET STATISTICS

SET TERM

SHADOW

SIGN()

SIN()

SINGULAR

SINH()

SKIP

SMALLINT

SQL

SQLCODE

SQRT()

STATEMENT

SUBSTRING()

SUM()

SWEEP

SYSDBA

TABLE

TAN()

TANH()

TIME

TIMESTAMP

TRAILING

TRANSACTION

TRIM()

TRUNC()

TYPE

UDF

UNION

UNIQUE

UPDATE

UPDATE OR INSERT

UPDATING

UPPER()

USER, CREATE USER, ALTER USER, DROP USER

USING

UUID_TO_CHAR()

VARCHAR(n)

VIEW

WEEKDAY

WHEN

WHERE

WHILE

YEAR

YEARDAY