Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SAP Sybase SQL Anywhere 16.0 (中文) » SQL Anywhere 服务器 - SQL 参考 » SQL 语句

 

SQL 语句

以下各节定义了所有支持的 SQL 语句的语法信息。


ALLOCATE DESCRIPTOR 语句 [ESQL]
ALTER DATABASE 语句
ALTER DBSPACE 语句
ALTER DOMAIN 语句
ALTER EVENT 语句
ALTER EXTERNAL ENVIRONMENT 语句
ALTER FUNCTION 语句
ALTER INDEX 语句
ALTER LDAP SERVER 语句
ALTER LOGIN POLICY 语句
ALTER MATERIALIZED VIEW 语句
ALTER MIRROR SERVER 语句
ALTER PROCEDURE 语句
ALTER PUBLICATION 语句 [MobiLink] [SQL Remote]
ALTER REMOTE MESSAGE TYPE 语句 [SQL Remote]
ALTER ROLE 语句
ALTER SEQUENCE 语句
ALTER SERVER 语句
ALTER SERVICE 语句 [HTTP Web 服务]
ALTER SERVICE 语句 [SOAP Web 服务]
ALTER SPATIAL REFERENCE SYSTEM 语句
ALTER STATISTICS 语句
ALTER SYNCHRONIZATION PROFILE 语句 [MobiLink]
ALTER SYNCHRONIZATION SUBSCRIPTION 语句 [MobiLink]
ALTER SYNCHRONIZATION USER 语句 [MobiLink]
ALTER TABLE 语句
ALTER TEXT CONFIGURATION 语句
ALTER TEXT INDEX 语句
ALTER TRACE EVENT SESSION 语句
ALTER TRIGGER 语句
ALTER USER 语句
ALTER VIEW 语句
ATTACH TRACING 语句
BACKUP 语句
BEGIN SNAPSHOT 语句
BEGIN 语句
BEGIN 语句 [TSQL]
BEGIN TRANSACTION 语句 [T-SQL]
BREAK 语句 [T-SQL]
CALL 语句
CASE 语句
CASE 语句 [T-SQL]
CHECKPOINT 语句
CLEAR 语句 [Interactive SQL]
CLOSE 语句 [ESQL] [SP]
COMMENT 语句
COMMIT 语句
CONFIGURE 语句 [Interactive SQL]
CONNECT 语句 [ESQL] [Interactive SQL]
CONTINUE 语句
CREATE CERTIFICATE 语句
CREATE DATABASE 语句
CREATE DBSPACE 语句
CREATE DECRYPTED DATABASE 语句
CREATE DECRYPTED FILE 语句
CREATE DOMAIN 语句
CREATE ENCRYPTED DATABASE 语句
CREATE ENCRYPTED FILE 语句
CREATE EVENT 语句
CREATE EXISTING TABLE 语句
CREATE EXTERNLOGIN 语句
CREATE FUNCTION 语句 [外部调用]
CREATE FUNCTION 语句 [Web 服务]
CREATE FUNCTION 语句
CREATE INDEX 语句
CREATE LDAP SERVER 语句
CREATE LOCAL TEMPORARY TABLE 语句
CREATE LOGIN POLICY 语句
CREATE MATERIALIZED VIEW 语句
CREATE MESSAGE 语句 [T-SQL]
CREATE MIRROR SERVER 语句
CREATE PROCEDURE 语句 [外部调用]
CREATE PROCEDURE 语句 [Web 服务]
CREATE PROCEDURE 语句 [T-SQL]
CREATE PROCEDURE 语句
CREATE PUBLICATION 语句 [MobiLink] [SQL Remote]
CREATE REMOTE [MESSAGE] TYPE 语句 [SQL Remote]
CREATE ROLE 语句
CREATE SCHEMA 语句
CREATE SEQUENCE 语句
CREATE SERVER 语句
CREATE SERVICE 语句 [HTTP Web 服务]
CREATE SERVICE 语句 [SOAP Web 服务]
CREATE SPATIAL REFERENCE SYSTEM 语句
CREATE SPATIAL UNIT OF MEASURE 语句
CREATE STATISTICS 语句
CREATE SUBSCRIPTION 语句 [SQL Remote]
CREATE SYNCHRONIZATION PROFILE 语句 [MobiLink]
CREATE SYNCHRONIZATION SUBSCRIPTION 语句 [MobiLink]
CREATE SYNCHRONIZATION USER 语句 [MobiLink]
CREATE TABLE 语句
CREATE TEMPORARY TRACE EVENT 语句
CREATE TEMPORARY TRACE EVENT SESSION 语句
CREATE TEXT CONFIGURATION 语句
CREATE TEXT INDEX 语句
CREATE TRIGGER 语句
CREATE TRIGGER 语句 [T-SQL]
CREATE USER 语句
CREATE VARIABLE 语句
CREATE VIEW 语句
DEALLOCATE DESCRIPTOR 语句 [ESQL]
DEALLOCATE 语句
声明部分 [ESQL]
DECLARE CURSOR 语句 [ESQL] [SP]
DECLARE LOCAL TEMPORARY TABLE 语句
DECLARE 语句
DELETE 语句(定位) [ESQL] [SP]
DELETE 语句
DESCRIBE 语句 [ESQL]
DESCRIBE 语句 [Interactive SQL]
DETACH TRACING 语句
DISCONNECT 语句 [ESQL] [Interactive SQL]
DROP CERTIFICATE 语句
DROP CONNECTION 语句
DROP DATABASE 语句
DROP DATATYPE 语句
DROP DBSPACE 语句
DROP DOMAIN 语句
DROP EVENT 语句
DROP EXTERNLOGIN 语句
DROP FUNCTION 语句
DROP INDEX 语句
DROP LDAP SERVER 语句
DROP LOGIN POLICY 语句
DROP MATERIALIZED VIEW 语句
DROP MESSAGE 语句
DROP MIRROR SERVER 语句
DROP PROCEDURE 语句
DROP PUBLICATION 语句 [MobiLink] [SQL Remote]
DROP REMOTE MESSAGE TYPE 语句 [SQL Remote]
DROP REMOTE CONNECTION 语句
DROP ROLE 语句
DROP SEQUENCE 语句
DROP SERVER 语句
DROP SERVICE 语句
DROP SPATIAL REFERENCE SYSTEM 语句
DROP SPATIAL UNIT OF MEASURE 语句
DROP STATEMENT 语句 [ESQL]
DROP STATISTICS 语句
DROP SUBSCRIPTION 语句 [SQL Remote]
DROP SYNCHRONIZATION PROFILE 语句 [MobiLink]
DROP SYNCHRONIZATION SUBSCRIPTION 语句 [MobiLink]
DROP SYNCHRONIZATION USER 语句 [MobiLink]
DROP TABLE 语句
DROP TEXT CONFIGURATION 语句
DROP TEXT INDEX 语句
DROP TRACE EVENT 语句
DROP TRACE EVENT SESSION 语句
DROP TRIGGER 语句
DROP USER 语句
DROP VARIABLE 语句
DROP VIEW 语句
EXCEPT 语句
EXECUTE IMMEDIATE 语句 [SP]
EXECUTE 语句 [ESQL]
EXECUTE 语句 [T-SQL]
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 CONNECT 语句
GRANT CONSOLIDATE 语句 [SQL Remote]
GRANT CREATE 语句
GRANT EXECUTE 语句
GRANT INTEGRATED LOGIN 语句
GRANT KERBEROS LOGIN 语句
GRANT PUBLISH 语句 [SQL Remote]
GRANT ROLE SYS_REPLICATION_ADMIN_ROLE 语句 [MobiLink] [SQL Remote]
GRANT ROLE SYS_RUN_REPLICATION_ROLE 语句 [MobiLink] [SQL Remote]
GRANT REMOTE 语句 [SQL Remote]
GRANT USAGE ON SEQUENCE 语句
GROUP BY 子句
HELP 语句 [Interactive SQL]
IF 语句
IF 语句 [T-SQL]
INCLUDE 语句 [ESQL]
INPUT 语句 [Interactive SQL]
INSERT 语句
INSTALL EXTERNAL OBJECT 语句
INSTALL JAVA 语句
INTERSECT 语句
LEAVE 语句
LOAD STATISTICS 语句
LOAD TABLE 语句
LOCK FEATURE 语句
LOCK TABLE 语句
LOOP 语句
MERGE 语句
MESSAGE 语句
NOTIFY TRACE EVENT 语句
OPEN 语句 [ESQL] [SP]
OUTPUT 语句 [Interactive SQL]
PARAMETERS 语句 [Interactive SQL]
PASSTHROUGH 语句 [SQL Remote]
PREPARE 语句 [ESQL]
PREPARE TO COMMIT 语句
PRINT 语句 [T-SQL]
PUT 语句 [ESQL]
RAISERROR 语句
READ 语句 [Interactive SQL]
READTEXT 语句 [T-SQL]
REFRESH MATERIALIZED VIEW 语句
REFRESH TEXT INDEX 语句
REFRESH TRACING LEVEL 语句
RELEASE SAVEPOINT 语句
REMOTE RESET 语句 [SQL Remote]
REMOVE EXTERNAL OBJECT 语句
REMOVE JAVA 语句
REORGANIZE TABLE 语句
RESIGNAL 语句 [SP]
RESTORE DATABASE 语句
RESUME 语句
RETURN 语句
REVOKE CONSOLIDATE 语句 [SQL Remote]
REVOKE PUBLISH 语句 [SQL Remote]
REVOKE REMOTE 语句 [SQL Remote]
REVOKE 语句
REVOKE ROLE SYS_REPLICATION_ADMIN_ROLE 语句 [MobiLink] [SQL Remote]
REVOKE ROLE SYS_RUN_REPLICATION_ROLE 语句 [MobiLink] [SQL Remote]
ROLLBACK 语句
ROLLBACK TO SAVEPOINT 语句
ROLLBACK TRANSACTION 语句 [T-SQL]
ROLLBACK TRIGGER 语句
SAVE TRANSACTION 语句 [T-SQL]
SAVEPOINT 语句
SELECT 语句
SET CONNECTION 语句 [Interactive SQL] [ESQL]
SET DESCRIPTOR 语句 [ESQL]
SET MIRROR OPTION 语句
SET OPTION 语句
SET OPTION 语句 [Interactive SQL]
SET REMOTE OPTION 语句 [SQL Remote]
SET SQLCA 语句 [ESQL]
SET 语句
SET 语句 [T-SQL]
SETUSER 语句
SIGNAL 语句 [SP]
START DATABASE 语句
START SERVER 语句 [Interactive SQL]
START EXTERNAL ENVIRONMENT 语句
START JAVA 语句
START LOGGING 语句 [Interactive SQL]
START SUBSCRIPTION 语句 [SQL Remote]
START SYNCHRONIZATION DELETE 语句 [MobiLink]
START SYNCHRONIZATION SCHEMA CHANGE 语句 [MobiLink]
STOP DATABASE 语句
STOP EXTERNAL ENVIRONMENT 语句
STOP JAVA 语句
STOP LOGGING 语句 [Interactive SQL]
STOP SERVER 语句
STOP SUBSCRIPTION 语句 [SQL Remote]
STOP SYNCHRONIZATION DELETE 语句 [MobiLink]
SYNCHRONIZE 语句 [MobiLink]
STOP SYNCHRONIZATION SCHEMA CHANGE 语句 [MobiLink]
SYNCHRONIZE SUBSCRIPTION 语句 [SQL Remote]
SYSTEM 语句 [Interactive SQL]
TRIGGER EVENT 语句
TRUNCATE 语句
TRUNCATE TEXT INDEX 语句
TRY 语句
UNION 语句
UNLOAD 语句
UPDATE(定位)语句 [ESQL] [SP]
UPDATE 语句 [SQL Remote]
UPDATE 语句
VALIDATE LDAP SERVER 语句
VALIDATE 语句
WAITFOR 语句
WHENEVER 语句 [ESQL]
WHILE 语句 [T-SQL]
WINDOW 子句
WRITETEXT 语句 [T-SQL]