SQL Anywhere Server - SQL 参考

SQL Anywhere 服务器

SQL 参考

上次修改时间 2007 年 3 月

版权和商标

版权所有 (c) 2007 iAnywhere Solutions, Inc. 部分版权所有 (c) 2007 Sybase, Inc. 保留所有权利。

iAnywhere Solutions, Inc. 是 Sybase, Inc. 的子公司。

iAnywhere 授权您将本文档用于参考、教育以及其它非商业用途，前提是 (1) 所有副本均含有文档中的本篇和所有其它版权和所有

权声明；(2) 不要企图将本文档据为己有；(3) 不对本文档进行修改。未经 iAnywhere 明确的事先书面许可，不得出版或发布本文

档及其任何部分。

文中提及的所有其它公司和产品名可能是与其相关的各个公司的商标。

目录

关于本手册 .................................................................................................... xi

SQL Anywhere 文档 ................................................................................................... xii

文档约定 ..................................................................................................................... xiv

查找详细信息并提供反馈 .......................................................................................... xviii

I. 使用 SQL ..................................................................................................... 1

SQL 语言元素 ................................................................................................................ 3

关键字 .................................................................................................................... 4

标识符 .................................................................................................................... 7

变量 ...................................................................................................................... 35

注释 ...................................................................................................................... 40

NULL 值 ............................................................................................................... 41

SQL 数据类型 .............................................................................................................. 45

字符数据类型 ....................................................................................................... 46

数字数据类型 ....................................................................................................... 54

Money 数据类型 ................................................................................................... 62

位数组数据类型 .................................................................................................... 63

日期和时间数据类型 ............................................................................................ 65

二进制数据类型 .................................................................................................... 72

Copyright © 2007, iAnywhere Solutions, Inc. iii

按字母顺序排序的函数列表 ................................................................................ 101

使用 SQL 语句参考 ............................................................................................ 287

ALLOCATE DESCRIPTOR 语句 [ESQL] ........................................................... 291

ALTER DATABASE 语句 ................................................................................... 293

ALTER DBSPACE 语句 ..................................................................................... 297

ALTER DOMAIN 语句 ........................................................................................ 299

ALTER EVENT 语句 .......................................................................................... 300

ALTER FUNCTION 语句 ................................................................................... 302

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

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 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

DEALLOCATE 语句 ........................................................................................... 458

DEALLOCATE DESCRIPTOR 语句 [ESQL] ...................................................... 459

声明部分 [ESQL] ................................................................................................ 460

DECLARE 语句 .................................................................................................. 461

Copyright © 2007, iAnywhere Solutions, Inc. v