SQL Anywhere 服务器
SQL 参考
上次修改时间 2007 年 3 月
版权和商标
版权所有 (c) 2007 iAnywhere Solutions, Inc. 部分版权所有 (c) 2007 Sybase, Inc. 保留所有权利。
iAnywhere Solutions, Inc. 是 Sybase, Inc. 的子公司。
iAnywhere 授权您将本文档用于参考、教育以及其它非商业用途，前提是 (1) 所有副本均含有文档中的本篇和所有其它版权和所有
权声明；(2) 不要企图将本文档据为己有；(3) 不对本文档进行修改。未经 iAnywhere 明确的事先书面许可，不得出版或发布本文
档及其任何部分。
本文档对 iAnywhere 采取或避免采取的任何活动均不做任何承诺，iAnywhere 可自行更改文档内容，恕不另行通知。除非在与
iAnywhere 达成的书面协议中另行规定，否则会原样提供文档，iAnywhere 对文档的使用及其可能包含的不准确性不承担任何责
任。
iAnywhere (R)、Sybase (R) 以及在 http://www.ianywhere.com/trademarks 上所列出的商标均为 Sybase, Inc. 或其子公司的商标。(R)
表示在美国注册。
Java 以及所有基于 Java 的商标均为 Sun Microsystems, Inc. 在美国和其它国家/地区的商标或注册商标。
文中提及的所有其它公司和产品名可能是与其相关的各个公司的商标。
目录
关于本手册 .................................................................................................... xi
SQL Anywhere 文档 ................................................................................................... xii
文档约定 ..................................................................................................................... xiv
查找详细信息并提供反馈 .......................................................................................... xviii
I. 使用 SQL ..................................................................................................... 1
SQL 语言元素 ................................................................................................................ 3
关键字 .................................................................................................................... 4
标识符 .................................................................................................................... 7
字符串 .................................................................................................................... 8
常量 ........................................................................................................................ 9
运算符 .................................................................................................................. 11
表达式 .................................................................................................................. 15
搜索条件 .............................................................................................................. 20
特殊值 .................................................................................................................. 29
变量 ...................................................................................................................... 35
注释 ...................................................................................................................... 40
NULL 值 ............................................................................................................... 41
SQL 数据类型 .............................................................................................................. 45
字符数据类型 ....................................................................................................... 46
数字数据类型 ....................................................................................................... 54
Money 数据类型 ................................................................................................... 62
位数组数据类型 .................................................................................................... 63
日期和时间数据类型 ............................................................................................ 65
二进制数据类型 .................................................................................................... 72
域 ......................................................................................................................... 75
数据类型转换 ....................................................................................................... 77
Java 和 SQL 数据类型转换 .................................................................................. 85
SQL 函数 ..................................................................................................................... 89
SQL 函数简介 ...................................................................................................... 90
函数类型 .............................................................................................................. 91
Copyright © 2007, iAnywhere Solutions, Inc. iii
按字母顺序排序的函数列表 ................................................................................ 101
SQL 语句 ................................................................................................................... 281
使用 SQL 语句参考 ............................................................................................ 287
ALLOCATE DESCRIPTOR 语句 [ESQL] ........................................................... 291
ALTER DATABASE 语句 ................................................................................... 293
ALTER DBSPACE 语句 ..................................................................................... 297
ALTER DOMAIN 语句 ........................................................................................ 299
ALTER EVENT 语句 .......................................................................................... 300
ALTER FUNCTION 语句 ................................................................................... 302
ALTER INDEX 语句 ........................................................................................... 303
ALTER MATERIALIZED VIEW 语句 .................................................................. 305
ALTER PROCEDURE 语句 ............................................................................... 307
ALTER PUBLICATION 语句 [MobiLink] [SQL Remote] ..................................... 309
ALTER REMOTE MESSAGE TYPE 语句 [SQL Remote] .................................. 311
ALTER SERVER 语句 ....................................................................................... 313
ALTER SERVICE 语句 ...................................................................................... 315
ALTER STATISTICS 语句 ................................................................................. 319
ALTER SYNCHRONIZATION SUBSCRIPTION 语句 [MobiLink] ...................... 320
ALTER SYNCHRONIZATION USER 语句 [MobiLink] ....................................... 322
ALTER TABLE 语句 ........................................................................................... 324
ALTER TRIGGER 语句 ...................................................................................... 332
ALTER VIEW 语句 ............................................................................................. 333
ATTACH TRACING 语句 ................................................................................... 335
BACKUP 语句 .................................................................................................... 337
BEGIN 语句 ....................................................................................................... 342
BEGIN TRANSACTION 语句 [T-SQL] ............................................................... 344
BREAK 语句 [T-SQL] ......................................................................................... 346
CALL 语句 .......................................................................................................... 347
CASE 语句 ......................................................................................................... 349
CHECKPOINT 语句 ........................................................................................... 351
CLEAR 语句 [Interactive SQL] ........................................................................... 352
CLOSE 语句 [ESQL] [SP] .................................................................................. 353
COMMENT 语句 ................................................................................................ 355
COMMIT 语句 .................................................................................................... 357
CONFIGURE 语句 [Interactive SQL] ................................................................. 359
SQL Anywhere 服务器 - SQL 参考
iv Copyright © 2007, iAnywhere Solutions, Inc.
CONNECT 语句 [ESQL] [Interactive SQL] ........................................................ 360
CONTINUE 语句 [T-SQL] .................................................................................. 363
CREATE DATABASE 语句 ................................................................................ 364
CREATE DBSPACE 语句 .................................................................................. 372
CREATE DECRYPTED FILE 语句 .................................................................... 374
CREATE DOMAIN 语句 ..................................................................................... 376
CREATE ENCRYPTED FILE 语句 .................................................................... 378
CREATE EVENT 语句 ....................................................................................... 380
CREATE EXISTING TABLE 语句 ...................................................................... 385
CREATE EXTERNLOGIN 语句 ......................................................................... 387
CREATE FUNCTION 语句 ................................................................................ 389
CREATE INDEX 语句 ........................................................................................ 395
CREATE LOCAL TEMPORARY TABLE 语句 ................................................... 399
CREATE MATERIALIZED VIEW 语句 ............................................................... 401
CREATE MESSAGE 语句 [T-SQL] .................................................................... 403
CREATE PROCEDURE 语句 ............................................................................ 404
CREATE PROCEDURE 语句 [T-SQL] .............................................................. 414
CREATE PUBLICATION 语句 [MobiLink] [SQL Remote] .................................. 416
CREATE REMOTE MESSAGE TYPE 语句 [SQL Remote] ............................... 419
CREATE SCHEMA 语句 .................................................................................... 421
CREATE SERVER 语句 .................................................................................... 423
CREATE SERVICE 语句 ................................................................................... 426
CREATE STATISTICS 语句 .............................................................................. 430
CREATE SUBSCRIPTION 语句 [SQL Remote] ................................................ 431
CREATE SYNCHRONIZATION SUBSCRIPTION 语句 [MobiLink] ................... 433
CREATE SYNCHRONIZATION USER 语句 [MobiLink] .................................... 435
CREATE TABLE 语句 ........................................................................................ 437
CREATE TRIGGER 语句 ................................................................................... 448
CREATE TRIGGER 语句 [T-SQL] ..................................................................... 453
CREATE VARIABLE 语句 ................................................................................. 454
CREATE VIEW 语句 .......................................................................................... 456
DEALLOCATE 语句 ........................................................................................... 458
DEALLOCATE DESCRIPTOR 语句 [ESQL] ...................................................... 459
声明部分 [ESQL] ................................................................................................ 460
DECLARE 语句 .................................................................................................. 461
SQL Anywhere 服务器 - SQL 参考
Copyright © 2007, iAnywhere Solutions, Inc. v
