SQL Reference Guide

SQL Statements

This chapter provides detailed reference material on each SQL statement.

In This Chapter Syntax Conventions ALTER INDEX ALTER SEQUENCE ALTER TABLE ALTER VIEW CALL COMMIT WORK CONNECT CREATE FUNCTION CREATE INDEX CREATE SEQUENCE CREATE PROCEDURE CREATE SYNONYM CREATE TABLE CREATE TRIGGER CREATE VIEW DELETE DISCONNECT DROP FUNCTION DROP INDEX DROP PROCEDURE DROP SEQUENCE DROP SYNONYM DROP TABLE DROP TRIGGER DROP VIEW EXPLAIN PLAN GET DIAGNOSTICS GRANT INSERT LOCK TABLE ORDER BY RENAME REVOKE ROLLBACK WORK SELECT SET IDENTITY_INSERT SET TRANSACTION ISOLATION SET SCHEMA TRUNCATE TABLE UPDATE UPDATE STATISTICS