Справочник по языку SQL# Содержание# Начало работы Основы архитектуры Создание базы данных Доступ к базе данных Язык SQL Введение Концепции Создание новой таблицы Заполнение таблицы строками Запрос к таблице Объединения между таблицами Агрегатные функции Обновление строк таблицы Удаление строк таблицы Команды SQL ABORT ALTER AGGREGATE ALTER COLLATION ALTER CONVERSION ALTER DATABASE ALTER DEFAULT PRIVILEGES ALTER DOMAIN ALTER EVENT TRIGGER ALTER EXTENSION ALTER FOREIGN DATA WRAPPER ALTER FOREIGN TABLE ALTER FUNCTION ALTER GROUP ALTER INDEX ALTER LANGUAGE ALTER LARGE OBJECT ALTER MATERIALIZED VIEW ALTER OPERATOR ALTER OPERATOR CLASS ALTER OPERATOR FAMILY ALTER POLICY ALTER PROCEDURE ALTER PUBLICATION ALTER ROLE ALTER ROUTINE ALTER RULE ALTER SCHEMA ALTER SEQUENCE ALTER SERVER ALTER STATISTICS ALTER SUBSCRIPTION ALTER SYSTEM ALTER TABLE ALTER TABLESPACE ALTER TEXT SEARCH CONFIGURATION ALTER TEXT SEARCH DICTIONARY ALTER TEXT SEARCH PARSER ALTER TEXT SEARCH TEMPLATE ALTER TRIGGER ALTER TYPE ALTER USER ALTER USER MAPPING ALTER VIEW ANALYZE BEGIN CALL CHECKPOINT CLOSE CLUSTER COMMENT COMMIT COMMIT PREPARED COPY CREATE ACCESS METHOD CREATE AGGREGATE CREATE CAST CREATE COLLATION CREATE CONVERSION CREATE DATABASE CREATE DOMAIN CREATE EVENT TRIGGER CREATE EXTENSION CREATE FOREIGN DATA WRAPPER CREATE FOREIGN TABLE CREATE FUNCTION CREATE GROUP CREATE INDEX CREATE LANGUAGE CREATE MATERIALIZED VIEW CREATE OPERATOR CREATE OPERATOR CLASS CREATE OPERATOR FAMILY CREATE POLICY CREATE PROCEDURE CREATE PUBLICATION CREATE ROLE CREATE RULE CREATE SCHEMA CREATE SEQUENCE CREATE SERVER CREATE STATISTICS CREATE SUBSCRIPTION CREATE TABLE CREATE TABLE AS CREATE TABLESPACE CREATE TEXT SEARCH CONFIGURATION CREATE TEXT SEARCH DICTIONARY CREATE TEXT SEARCH PARSER CREATE TEXT SEARCH TEMPLATE CREATE TRANSFORM CREATE TRIGGER CREATE TYPE CREATE USER CREATE USER MAPPING CREATE VIEW DEALLOCATE DECLARE DELETE DISCARD DO DROP ACCESS METHOD DROP AGGREGATE DROP CAST DROP COLLATION DROP CONVERSION DROP DATABASE DROP DOMAIN DROP EVENT TRIGGER DROP EXTENSION DROP FOREIGN DATA WRAPPER DROP FOREIGN TABLE DROP FUNCTION DROP GROUP DROP INDEX DROP LANGUAGE DROP MATERIALIZED VIEW DROP OPERATOR DROP OPERATOR CLASS DROP OPERATOR FAMILY DROP OWNED DROP POLICY DROP PROCEDURE DROP PUBLICATION DROP ROLE DROP ROUTINE DROP RULE DROP SCHEMA DROP SEQUENCE DROP SERVER DROP STATISTICS DROP SUBSCRIPTION DROP TABLE DROP TABLESPACE DROP TEXT SEARCH CONFIGURATION DROP TEXT SEARCH DICTIONARY DROP TEXT SEARCH PARSER DROP TEXT SEARCH TEMPLATE DROP TRANSFORM DROP TRIGGER DROP TYPE DROP USER DROP USER MAPPING DROP VIEW END EXECUTE EXPLAIN FETCH GRANT IMPORT FOREIGN SCHEMA INSERT LISTEN LOAD LOCK MERGE MOVE NOTIFY PREPARE PREPARE TRANSACTION REASSIGN OWNED REFRESH MATERIALIZED VIEW REINDEX RELEASE SAVEPOINT RESET REVOKE ROLLBACK ROLLBACK PREPARED ROLLBACK TO SAVEPOINT SAVEPOINT SECURITY LABEL SELECT SELECT INTO SET SET CONSTRAINTS SET ROLE SET SESSION AUTHORIZATION SET TRANSACTION SHOW START TRANSACTION TRUNCATE UNLISTEN UPDATE VACUUM VALUES Ключевые слова SQL Соответствие стандарту SQL Поддерживаемые возможности Неподдерживаемые возможности Ограничения XML и совместимость с SQL/XML