本章按字母顺序列出了 SQL 语句的详细说明。
使用 SQL 语句参考
ALLOCATE DESCRIPTOR 语句 [ESQL]
ALTER DATABASE 语句
ALTER DBSPACE 语句
ALTER DOMAIN 语句
ALTER EVENT 语句
ALTER FUNCTION 语句
ALTER INDEX 语句
ALTER PROCEDURE 语句
ALTER PUBLICATION 语句
ALTER REMOTE MESSAGE TYPE 语句 [SQL Remote]
ALTER SERVER 语句
ALTER SERVICE 语句
ALTER SYNCHRONIZATION SUBSCRIPTION 语句 [MobiLink]
ALTER SYNCHRONIZATION USER 语句 [MobiLink]
ALTER TABLE 语句
ALTER TRIGGER 语句
ALTER VIEW 语句
ALTER WRITEFILE 语句(不建议使用)
BACKUP 语句
BEGIN 语句
BEGIN TRANSACTION 语句
CALL 语句
CASE 语句
CHECKPOINT 语句
CLEAR 语句 [Interactive SQL]
CLOSE 语句 [ESQL] [SP]
COMMENT 语句
COMMIT 语句
CONFIGURE 语句 [Interactive SQL]
CONNECT 语句 [ESQL] [Interactive SQL]
CREATE COMPRESSED DATABASE 语句(不建议使用)
CREATE DATABASE 语句
CREATE DBSPACE 语句
CREATE DECRYPTED FILE 语句
CREATE DOMAIN 语句
CREATE ENCRYPTED FILE 语句
CREATE EVENT 语句
CREATE EXISTING TABLE 语句
CREATE EXTERNLOGIN 语句
CREATE FUNCTION 语句
CREATE INDEX 语句
CREATE MESSAGE 语句 [T-SQL]
CREATE PROCEDURE 语句
CREATE PROCEDURE 语句 [T-SQL]
CREATE PUBLICATION 语句
CREATE REMOTE MESSAGE TYPE 语句 [SQL Remote]
CREATE SCHEMA 语句
CREATE SERVER 语句
CREATE SERVICE 语句
CREATE STATISTICS 语句
CREATE SUBSCRIPTION 语句 [SQL Remote]
CREATE SYNCHRONIZATION SUBSCRIPTION 语句 [MobiLink]
CREATE SYNCHRONIZATION USER 语句 [MobiLink]
CREATE TABLE 语句
CREATE TRIGGER 语句
CREATE TRIGGER 语句 [SQL Remote]
CREATE TRIGGER 语句 [T-SQL]
CREATE VARIABLE 语句
CREATE VIEW 语句
CREATE WRITEFILE 语句(不建议使用)
DEALLOCATE 语句
DEALLOCATE DESCRIPTOR 语句 [ESQL]
声明部分 [ESQL]
DECLARE 语句
DECLARE CURSOR 语句 [ESQL] [SP]
DECLARE CURSOR 语句 [T-SQL]
DECLARE LOCAL TEMPORARY TABLE 语句
DELETE 语句
DELETE(定位)语句 [ESQL] [SP]
DESCRIBE 语句 [ESQL]
DISCONNECT 语句 [ESQL] [Interactive SQL]
DROP 语句
DROP DATABASE 语句
DROP CONNECTION 语句
DROP EXTERNLOGIN 语句
DROP PUBLICATION 语句
DROP REMOTE MESSAGE TYPE 语句 [SQL Remote]
DROP SERVER 语句
DROP SERVICE 语句
DROP STATEMENT 语句 [ESQL]
DROP STATISTICS 语句
DROP SUBSCRIPTION 语句 [SQL Remote]
DROP SYNCHRONIZATION SUBSCRIPTION 语句 [MobiLink]
DROP SYNCHRONIZATION USER 语句 [MobiLink]
DROP VARIABLE 语句
EXCEPT 操作
EXECUTE 语句 [ESQL]
EXECUTE 语句 [T-SQL]
EXECUTE IMMEDIATE 语句 [SP]
EXIT 语句 [Interactive SQL]
EXPLAIN 语句 [ESQL]
FETCH 语句 [ESQL] [SP]
FOR 语句
FORWARD TO 语句
FROM 子句
GET DATA 语句 [ESQL]
GET DESCRIPTOR 语句 [ESQL]
GET OPTION 语句 [ESQL]
GOTO 语句 [T-SQL]
GRANT 语句
GRANT CONSOLIDATE 语句 [SQL Remote]
GRANT PUBLISH 语句 [SQL Remote]
GRANT REMOTE 语句 [SQL Remote]
GRANT REMOTE DBA 语句 [SQL Remote]
GROUP BY 子句
HELP 语句 [Interactive SQL]
IF 语句
IF 语句 [T-SQL]
INCLUDE 语句 [ESQL]
INPUT 语句 [Interactive SQL]
INSERT 语句
INSTALL JAVA 语句
INTERSECT 操作
LEAVE 语句
LOAD STATISTICS 语句
LOAD TABLE 语句
LOCK TABLE 语句
LOOP 语句
MESSAGE 语句
OPEN 语句 [ESQL] [SP]
OUTPUT 语句 [Interactive SQL]
PARAMETERS 语句 [Interactive SQL]
PASSTHROUGH 语句 [SQL Remote]
PREPARE 语句 [ESQL]
PREPARE TO COMMIT 语句
PRINT 语句 [T-SQL]
PUT 语句 [ESQL]
RAISERROR 语句 [T-SQL]
READ 语句 [Interactive SQL]
READTEXT 语句 [T-SQL]
RELEASE SAVEPOINT 语句
REMOTE RESET 语句 [SQL Remote]
REMOVE JAVA 语句
REORGANIZE TABLE 语句
RESIGNAL 语句
RESTORE DATABASE 语句
RESUME 语句
RETURN 语句
REVOKE 语句
REVOKE CONSOLIDATE 语句 [SQL Remote]
REVOKE PUBLISH 语句 [SQL Remote]
REVOKE REMOTE 语句 [SQL Remote]
REVOKE REMOTE DBA 语句 [SQL Remote]
ROLLBACK 语句
ROLLBACK TO SAVEPOINT 语句
ROLLBACK TRANSACTION 语句
ROLLBACK TRIGGER 语句
SAVE TRANSACTION 语句
SAVEPOINT 语句
SELECT 语句
SET 语句
SET 语句 [T-SQL]
SET CONNECTION 语句 [Interactive SQL] [ESQL]
SET DESCRIPTOR 语句 [ESQL]
SET OPTION 语句
SET OPTION 语句 [Interactive SQL]
SET REMOTE OPTION 语句 [SQL Remote]
SET SQLCA 语句 [ESQL]
SETUSER 语句
SIGNAL 语句
START DATABASE 语句 [Interactive SQL]
START ENGINE 语句 [Interactive SQL]
START JAVA 语句
START LOGGING 语句 [Interactive SQL]
START SUBSCRIPTION 语句 [SQL Remote]
START SYNCHRONIZATION DELETE 语句 [MobiLink]
STOP DATABASE 语句
STOP ENGINE 语句
STOP JAVA 语句
STOP LOGGING 语句 [Interactive SQL]
STOP SUBSCRIPTION 语句 [SQL Remote]
STOP SYNCHRONIZATION DELETE 语句 [MobiLink]
SYNCHRONIZE SUBSCRIPTION 语句 [SQL Remote]
SYSTEM 语句 [Interactive SQL]
TRIGGER EVENT 语句
TRUNCATE TABLE 语句
UNION 操作
UNLOAD 语句
UNLOAD TABLE 语句
UPDATE 语句
UPDATE(定位)语句 [ESQL] [SP]
UPDATE 语句 [SQL Remote]
VALIDATE CHECKSUM 语句
VALIDATE INDEX 语句
VALIDATE TABLE 语句
WAITFOR 语句
WHENEVER 语句 [ESQL]
WHILE 语句 [T-SQL]
WRITETEXT 语句 [T-SQL]
SQL Anywhere Studio 9.0.2
版权所有 © 1989–2005 Sybase, Inc. 部分版权所有 © 2001–2005 iAnywhere Solutions, Inc. 保留所有权利。