Sybase Adaptive Server Anywhere - Page 5

v
8 SQL Functions............................................................... 303
Function types.......................................................................304
Alphabetical list of functions..................................................313
9 SQL Statements............................................................. 377
Using the SQL statement reference......................................378
ALLOCATE DESCRIPTOR statement [ESQL].....................381
ALTER DATABASE statement .............................................383
ALTER DBSPACE statement ...............................................385
ALTER EVENT statement.....................................................387
ALTER PROCEDURE statement..........................................389
ALTER SERVER statement..................................................390
ALTER TABLE statement .....................................................392
ALTER TRIGGER statement ................................................398
ALTER VIEW statement .......................................................399
ALTER WRITEFILE statement .............................................400
BACKUP statement ..............................................................401
BEGIN statement ..................................................................404
BEGIN TRANSACTION statement .......................................407
CALL statement ....................................................................410
CASE statement....................................................................412
CHECKPOINT statement......................................................414
CLEAR statement [Interactive SQL] .....................................415
CLOSE statement [ESQL] [SP].............................................416
COMMENT statement...........................................................418
COMMIT statement...............................................................420
CONFIGURE statement [Interactive SQL]............................422
CONNECT statement [ESQL] [Interactive SQL]...................423
CREATE COMPRESSED DATABASE statement................426
CREATE DATABASE statement ..........................................427
CREATE DBSPACE statement ............................................431
CREATE DOMAIN statement ...............................................433
CREATE EVENT statement..................................................435
CREATE EXISTING TABLE statement ................................441
CREATE EXTERNLOGIN statement....................................443
CREATE FUNCTION statement...........................................445
CREATE INDEX statement...................................................448
CREATE MESSAGE statement [T-SQL] ..............................452
CREATE PROCEDURE statement.......................................453
CREATE PROCEDURE statement [T-SQL].........................460
CREATE SCHEMA statement ..............................................462
CREATE SERVER statement...............................................464
CREATE TABLE statement ..................................................466
CREATE TRIGGER statement .............................................477
CREATE TRIGGER statement [T-SQL] ...............................480