Ce chapitre présente des descriptions détaillées des instructions SQL, dans l'ordre alphabétique.
Conventions utilisées pour les instructions SQL
Instruction ALLOCATE DESCRIPTOR [ESQL]
Instruction ALTER DATABASE
Instruction ALTER DBSPACE
Instruction ALTER DOMAIN
Instruction ALTER EVENT
Instruction ALTER FUNCTION
Instruction ALTER INDEX
Instruction ALTER PROCEDURE
Instruction ALTER PUBLICATION
Instruction ALTER REMOTE MESSAGE TYPE [SQL Remote]
Instruction ALTER SERVER
Instruction ALTER SERVICE
Instruction ALTER SYNCHRONIZATION SUBSCRIPTION [MobiLink]
Instruction ALTER SYNCHRONIZATION USER [MobiLink]
Instruction ALTER TABLE
Instruction ALTER TRIGGER
Instruction ALTER VIEW
Instruction ALTER WRITEFILE (déconseillée)
Instruction BACKUP
Instruction BEGIN
Instruction BEGIN TRANSACTION
Instruction CALL
Instruction CASE
Instruction CHECKPOINT
Instruction CLEAR [Interactive SQL]
Instruction CLOSE [ESQL] [SP]
Instruction COMMENT
Instruction COMMIT
Instruction CONFIGURE [Interactive SQL]
Instruction CONNECT [ESQL] [Interactive SQL]
Instruction CREATE COMPRESSED DATABASE (déconseillée)
Instruction CREATE DATABASE
Instruction CREATE DBSPACE
Instruction CREATE DECRYPTED FILE
Instruction CREATE DOMAIN
Instruction CREATE ENCRYPTED FILE
Instruction CREATE EVENT
Instruction CREATE EXISTING TABLE
Instruction CREATE EXTERNLOGIN
Instruction CREATE FUNCTION
Instruction CREATE INDEX
Instruction CREATE MESSAGE [T-SQL]
Instruction CREATE PROCEDURE
Instruction CREATE PROCEDURE [T-SQL]
Instruction CREATE PUBLICATION
Instruction CREATE REMOTE MESSAGE TYPE [SQL Remote]
Instruction CREATE SCHEMA
Instruction CREATE SERVER
Instruction CREATE SERVICE
Instruction CREATE STATISTICS
Instruction CREATE SUBSCRIPTION [SQL Remote]
Instruction CREATE SYNCHRONIZATION SUBSCRIPTION [MobiLink]
Instruction CREATE SYNCHRONIZATION USER [MobiLink]
Instruction CREATE TABLE
Instruction CREATE TRIGGER
Instruction CREATE TRIGGER [SQL Remote]
Instruction CREATE TRIGGER [T-SQL]
Instruction CREATE VARIABLE
Instruction CREATE VIEW
Instruction CREATE WRITEFILE (déconseillée)
Instruction DEALLOCATE
Instruction DEALLOCATE DESCRIPTOR [ESQL]
Section de déclaration [ESQL]
Instruction DECLARE
Instruction DECLARE CURSOR [ESQL] [SP]
Instruction DECLARE CURSOR [T-SQL]
Instruction DECLARE LOCAL TEMPORARY TABLE
Instruction DELETE
Instruction DELETE (positionnée) [ESQL] [SP]
Instruction DESCRIBE [ESQL]
Instruction DISCONNECT [ESQL] [Interactive SQL]
Instruction DROP
Instruction DROP DATABASE
Instruction DROP CONNECTION
Instruction DROP EXTERNLOGIN
Instruction DROP PUBLICATION
Instruction DROP REMOTE MESSAGE TYPE [SQL Remote]
Instruction DROP SERVER
Instruction DROP SERVICE
Instruction DROP STATEMENT [ESQL]
Instruction DROP STATISTICS
Instruction DROP SUBSCRIPTION [SQL Remote]
Instruction DROP SYNCHRONIZATION SUBSCRIPTION [MobiLink]
Instruction DROP SYNCHRONIZATION USER [MobiLink]
Instruction DROP VARIABLE
Opération EXCEPT
Instruction EXECUTE [ESQL]
Instruction EXECUTE [T-SQL]
Instruction EXECUTE IMMEDIATE [SP]
Instruction EXIT [Interactive SQL]
Instruction EXPLAIN [ESQL]
Instruction FETCH [ESQL] [SP]
Instruction FOR
Instruction FORWARD TO
Clause FROM
Instruction GET DATA [ESQL]
Instruction GET DESCRIPTOR [ESQL]
Instruction GET OPTION [ESQL]
Instruction GOTO [T-SQL]
Instruction GRANT
Instruction GRANT CONSOLIDATE [SQL Remote]
Instruction GRANT PUBLISH [SQL Remote]
Instruction GRANT REMOTE [SQL Remote]
Instruction GRANT REMOTE DBA [SQL Remote]
Clause GROUP BY
Instruction HELP [Interactive SQL]
Instruction IF
Instruction IF [T-SQL]
Instruction INCLUDE [ESQL]
Instruction INPUT [Interactive SQL]
Instruction INSERT
Instruction INSTALL JAVA
Opération INTERSECT
Instruction LEAVE
Instruction LOAD STATISTICS
Instruction LOAD TABLE
Instruction LOCK TABLE
Instruction LOOP
Instruction MESSAGE
Instruction OPEN [ESQL] [SP]
Instruction OUTPUT [Interactive SQL]
Instruction PARAMETERS [Interactive SQL]
Instruction PASSTHROUGH [SQL Remote]
Instruction PREPARE [ESQL]
Instruction PREPARE TO COMMIT
Instruction PRINT [T-SQL]
Instruction PUT [ESQL]
Instruction RAISERROR [T-SQL]
Instruction READ [Interactive SQL]
Instruction READTEXT [T-SQL]
Instruction RELEASE SAVEPOINT
Instruction REMOTE RESET [SQL Remote]
Instruction REMOTE JAVA
Instruction REORGANIZE TABLE
Instruction RESIGNAL
Instruction RESTORE DATABASE
Instruction RESUME
Instruction RETURN
Instruction REVOKE
Instruction REVOKE CONSOLIDATE [SQL Remote]
Instruction REVOKE PUBLISH [SQL Remote]
Instruction REVOKE REMOTE [SQL Remote]
Instruction REVOKE REMOTE DBA [SQL Remote]
Instruction ROLLBACK
Instruction ROLLBACK TO SAVEPOINT
Instruction ROLLBACK TRANSACTION
Instruction ROLLBACK TRIGGER
Instruction SAVE TRANSACTION
Instruction SAVEPOINT
Instruction SELECT
Instruction SET
Instruction SET [T-SQL]
Instruction SET CONNECTION [Interactive SQL] [ESQL]
Instruction SET DESCRIPTOR [ESQL]
Instruction SET OPTION
Instruction SET OPTION [Interactive SQL]
Instruction SET REMOTE OPTION [SQL Remote]
Instruction SET SQLCA [ESQL]
Instruction SETUSER
Instruction SIGNAL
Instruction START DATABASE [Interactive SQL]
Instruction START ENGINE [Interactive SQL]
Instruction START JAVA
Instruction START LOGGING [Interactive SQL]
Instruction START SUBSCRIPTION [SQL Remote]
Instruction START SYNCHRONIZATION DELETE [MobiLink]
Instruction STOP DATABASE
Instruction STOP ENGINE
Instruction STOP JAVA
Instruction STOP LOGGING [Interactive SQL]
Instruction STOP SUBSCRIPTION [SQL Remote]
Instruction STOP SYNCHRONIZATION DELETE [MobiLink]
Instruction SYNCHRONIZE SUBSCRIPTION [SQL Remote]
Instruction SYSTEM [Interactive SQL]
Instruction TRIGGER EVENT
Instruction TRUNCATE TABLE
Opération UNION
Instruction UNLOAD
Instruction UNLOAD TABLE
Instruction UPDATE
Instruction UPDATE (positionnée) [ESQL] [SP]
Instruction UPDATE [SQL Remote]
Instruction VALIDATE CHECKSUM
Instruction VALIDATE INDEX
Instruction VALIDATE TABLE
Instruction WAITFOR
Instruction WHENEVER [ESQL]
Instruction WHILE [T-SQL]
Instruction WRITETEXT [T-SQL]
SQL Anywhere Studio 9.0.2
Copyright © 1989–2004 Sybase, Inc. Copyright partiel © 2001–2004 iAnywhere Solutions, Inc. Tous droits réservés.