| cache: flushing | sa_flush_cache system procedure |
| calibrating the server | ALTER DATABASE statement |
| CALL statement: in Transact-SQL | EXECUTE statement [T-SQL] |
| CALL statement: SQL syntax | CALL statement |
| calling: procedures | CALL statement |
| capabilities: remote servers | SYSCAPABILITY system table SYSCAPABILITYNAME system table |
| CASCADE action: CREATE TABLE statement | CREATE TABLE statement |
| CASE expression: NULLIF function | NULLIF function [Miscellaneous] |
| CASE expression: SQL syntax | CASE expressions |
| case sensitivity: and SQL LIKE conditions | LIKE conditions |
| case sensitivity: comparison operators | Comparison operators |
| case sensitivity: in the catalog | SYSINFO system table |
| CASE statement: SQL syntax | CASE statement |
| CAST function: data type conversions | Data type conversions |
| CAST function: SQL syntax | CAST function [Data type conversion] |
| catalog procedures (ASE): sp_columns | Adaptive Server Enterprise catalog procedures |
| catalog procedures (ASE): sp_column_privileges | Adaptive Server Enterprise catalog procedures |
| catalog procedures (ASE): sp_fkeys | Adaptive Server Enterprise catalog procedures |
| catalog procedures (ASE): sp_pkeys | Adaptive Server Enterprise catalog procedures |
| catalog procedures (ASE): sp_special_columns | Adaptive Server Enterprise catalog procedures |
| catalog procedures (ASE): sp_sproc_columns | Adaptive Server Enterprise catalog procedures |
| catalog procedures (ASE): sp_stored_procedures | Adaptive Server Enterprise catalog procedures |
| catalog procedures (ASE): sp_tables | Adaptive Server Enterprise catalog procedures |
| catalog procedures (ASE): Transact-SQL list | Adaptive Server Enterprise system and catalog procedures |
| catalog procedures (ASE): Transact-SQL, list | Adaptive Server Enterprise catalog procedures |
| catalog procedures: list | System and catalog stored procedures |
| catalog system procedures: about | System Procedures and Functions |
| catalog: system tables | System Tables |
| CEILING function: SQL syntax | CEILING function [Numeric] |
| certificate_company stream parameter: MobiLink clients using HTTP | CREATE SYNCHRONIZATION USER statement [MobiLink] |
| certificate_company stream parameter: MobiLink clients using HTTPS | CREATE SYNCHRONIZATION USER statement [MobiLink] |
| certificate_company stream parameter: MobiLink clients using TCP/IP | CREATE SYNCHRONIZATION USER statement [MobiLink] |
| certificate_name stream parameter: MobiLink clients using HTTP | CREATE SYNCHRONIZATION USER statement [MobiLink] |
| certificate_name stream parameter: MobiLink clients using HTTPS | CREATE SYNCHRONIZATION USER statement [MobiLink] |
| certificate_name stream parameter: MobiLink clients using TCP/IP | CREATE SYNCHRONIZATION USER statement [MobiLink] |
| certificate_unit stream parameter: MobiLink clients using HTTP | CREATE SYNCHRONIZATION USER statement [MobiLink] |
| certificate_unit stream parameter: MobiLink clients using HTTPS | CREATE SYNCHRONIZATION USER statement [MobiLink] |
| certificate_unit stream parameter: MobiLink clients using TCP/IP | CREATE SYNCHRONIZATION USER statement [MobiLink] |
| chained transaction mode | BEGIN TRANSACTION statement |
| changing: passwords | GRANT statement |
| CHAR data type: about | CHAR data type [Character] |
| CHAR function: SQL syntax | CHAR function [String] |
| CHARACTER data type: about | CHAR data type [Character] |
| character data: about | Character data types |
| character data: Adaptive Server Enterprise compatibility | Character data types |
| character data: strings | Strings |
| character functions: alphabetical list | String functions |
| character sets: SORTKEY function | SORTKEY function [String] |
| character sets: storage | Character data types |
| character strings: about | Strings |
| CHARACTER VARYING data type: about | CHARACTER VARYING (VARCHAR) data type [Character] |
| CHARINDEX function: SQL syntax | CHARINDEX function [String] |
| CHAR_LENGTH function: SQL syntax | CHAR_LENGTH function [String] |
| CHECK clause: search conditions | Search conditions |
| CHECK conditions: about | CREATE TABLE statement |
| CHECK CONSTRAINTS option: LOAD TABLE statement | LOAD TABLE statement |
| CHECK ON COMMIT clause: referential integrity | CREATE TABLE statement |
| checkpoint logs: CHECKPOINT SQL statement | CHECKPOINT statement |
| CHECKPOINT statement: SQL syntax | CHECKPOINT statement |
| checkpointing: databases | CHECKPOINT statement |
| classes: installing Java in the database | INSTALL JAVA statement |
| classes: Java methods | Java and SQL user-defined functions |
| classes: removing Java | REMOVE JAVA statement |
| CLEAR statement: SQL syntax | CLEAR statement [Interactive SQL] |
| clearing: Interactive SQL panes | CLEAR statement [Interactive SQL] |
| client_port number: default for MobiLink clients using HTTPS | CREATE SYNCHRONIZATION USER statement [MobiLink] |
| client_port stream parameter: MobiLink clients using HTTP | CREATE SYNCHRONIZATION USER statement [MobiLink] |
| client_port stream parameter: MobiLink clients using TCP/IP | CREATE SYNCHRONIZATION USER statement [MobiLink] |
| CLOSE statement: SQL syntax | CLOSE statement [ESQL] [SP] |
| CLOSE_ON_ENDTRANS option: Adaptive Server Enterprise compatibility | SET statement [T-SQL] |
| closing: connections | DROP CONNECTION statement |
| closing: cursors | CLOSE statement [ESQL] [SP] |
| closing: Interactive SQL | EXIT statement [Interactive SQL] |
| clustered indexes: ALTER INDEX statement | ALTER INDEX statement |
| COALESCE function: SQL syntax | COALESCE function [Miscellaneous] |
| code pages: CREATE DATABASE statement | CREATE DATABASE statement |
| code pages: data storage | Character data types |
| code pages: SYSCOLLATION system table | SYSCOLLATION system table |
| collation sequences | SQL Language Elements |
| collation sequences: and SQL LIKE conditions | LIKE conditions |
| collation sequences: CREATE DATABASE statement | CREATE DATABASE statement |
| collation sequences: SYSCOLLATION system table | SYSCOLLATION system table |
| collations: SORTKEY function | SORTKEY function [String] |
| column long names | DESCRIBE statement [ESQL] |
| column names in expressions | Column names in expressions |
| column names: SQL syntax | Column names in expressions |
| column statistics: selectivity estimates | Explicit selectivity estimates |
| column statistics: SYSCOLSTAT system table | SYSCOLSTAT system table |
| column statistics: SYSCOLSTATS system view | SYSCOLSTATS system view |
| column statistics: updating with CREATE STATISTICS | CREATE STATISTICS statement |
| column statistics: updating with LOAD TABLE | LOAD TABLE statement |
| columns: aliases | SELECT statement |
| columns: altering | ALTER TABLE statement |
| columns: constraints | Domains CREATE TABLE statement |
| columns: domains | Domains |
| columns: getting binary data from | GET DATA statement [ESQL] |
| columns: in the system tables | SYSCOLUMN system table |
| columns: permissions on | SYSCOLPERM system table |
| columns: renaming | ALTER TABLE statement |
| columns: SYSCOLUMNS system view | SYSCOLUMNS system view |
| columns: updating | UPDATE statement [SQL Remote] |
| columns: updating without logging | WRITETEXT statement [T-SQL] |
| columns: user-defined data types | Domains |
| col_length Adaptive Server Enterprise function | System functions |
| col_name Adaptive Server Enterprise function | System functions |
| combining: result of multiple select statements | UNION operation |
| comma-separated lists: LIST function syntax | LIST function [Aggregate] |
| command files: parameters for Interactive SQL | PARAMETERS statement [Interactive SQL] |
| command files: reading SQL statements from | READ statement [Interactive SQL] |
| commands: executing operating system | SYSTEM statement [Interactive SQL] |
| COMMENT statement: SQL syntax | COMMENT statement |
| comments: database objects | COMMENT statement |
| comments: services | COMMENT statement |
| comments: SQL syntax | Comments |
| COMMIT statement: referential integrity | sa_check_commit system procedure |
| COMMIT statement: SQL syntax | COMMIT statement |
| commit: preparing for two-phase | PREPARE TO COMMIT statement |
| committing: transactions | COMMIT statement |
| common elements in SQL syntax | Common elements in SQL syntax |
| communication protocols: multiple settings in MobiLink | CREATE SYNCHRONIZATION USER statement [MobiLink] |
| COMPARE function: SQL syntax | COMPARE function [String] |
| comparing dates and times | Comparing dates and times in the database |
| comparison operators: compatibility with Adaptive Server Enterprise | Comparison operators |
| comparison operators: data conversion | Conversion when using comparison operators |
| comparison operators: SQL syntax | Comparison operators |
| comparison operators: Transact-SQL compatibility | Comparison operators |
| comparisons: search conditions | Search conditions |
| compatibility of expressions | Compatibility of expressions |
| compatibility: datetime | Transact-SQL compatibility of string-to-date/time conversions |
| compatibility: NULLs | NULL value |
| compatibility: T-SQL expressions and QUOTED IDENTIFIER option | The quoted_identifier option |
| compatibility: Transact-SQL comparison operators | Comparison operators |
| compatibility: Transact-SQL expressions | Compatibility of expressions |
| compatibility: Transact-SQL global variables | Global variables |
| compatibility: Transact-SQL local variables | Local variables |
| compound statements: about | BEGIN statement |
| compound statements: compatibility | BEGIN statement |
| compressed databases: creating | CREATE COMPRESSED DATABASE statement |
| compression: statistics | sa_conn_compression_info system procedure |
| concatenating strings: string operators | String operators |
| concurrency: locking tables | LOCK TABLE statement |
| conditions: ALL | ALL or ANY conditions |
| conditions: ANY | ALL or ANY conditions |
| conditions: BETWEEN | BETWEEN conditions |
| conditions: EXISTS | EXISTS conditions |
| conditions: IN | IN conditions |
| conditions: IS NULL | IS NULL conditions |
| conditions: LIKE | LIKE conditions |
| conditions: search | Search conditions |
| conditions: SQL search conditions | Search conditions |
| conditions: subqueries in | Subqueries in search conditions |
| conditions: three-valued logic | Three-valued logic |
| conditions: truth value | Truth value conditions |
| CONFIGURE statement: SQL syntax | CONFIGURE statement [Interactive SQL] |
| CONNECT authority: granting permissions | GRANT statement |
| CONNECT statement: SQL syntax | CONNECT statement [ESQL] [Interactive SQL] |
| connecting: creating events for | CREATE EVENT statement |
| connecting: to databases | CONNECT statement [ESQL] [Interactive SQL] |
| connection-level variables: SQL syntax | Connection-level variables |
| connections: creating events for failed | CREATE EVENT statement |
| connections: disallowing with RAISERROR | RAISERROR statement [T-SQL] |
| connections: dropping | DROP CONNECTION statement |
| connections: dropping in Interactive SQL | DISCONNECT statement [ESQL] [Interactive SQL] |
| connections: enabling pooling | SETUSER statement |
| connections: setting | SET CONNECTION statement [Interactive SQL] [ESQL] |
| connections: setting a maximum number | RAISERROR statement [T-SQL] |
| CONNECTION_PROPERTY function: SQL syntax | CONNECTION_PROPERTY function [System] |
| console: displaying messages on | MESSAGE statement |
| CONSOLIDATE permissions: granting | GRANT CONSOLIDATE statement [SQL Remote] |
| CONSOLIDATE permissions: revoking | REVOKE CONSOLIDATE statement [SQL Remote] |
| consolidated databases: publishing | REVOKE PUBLISH statement [SQL Remote] |
| consolidated databases: revoking permissions | REVOKE CONSOLIDATE statement [SQL Remote] |
| constants in expressions | Constants in expressions |
| constants: SQL strings | Strings |
| constants: SQL syntax | Constants in expressions |
| constants: Transact-SQL | Compatibility of expressions |
| constraints: ALTER TABLE statement | ALTER TABLE statement |
| constraints: column | CREATE TABLE statement |
| CONTINUE statement: Transact-SQL syntax | WHILE statement [T-SQL] |
| control statements: CALL SQL statement | CALL statement |
| control statements: CASE SQL statement | CASE statement |
| control statements: GOTO Transact-SQL statement | GOTO statement [T-SQL] |
| control statements: IF SQL statement | IF statement |
| control statements: LEAVE SQL statement | LEAVE statement |
| control statements: LOOP SQL statement | LOOP statement |
| control statements: Transact-SQL BREAK statement | WHILE statement [T-SQL] |
| control statements: Transact-SQL CONTINUE statement | WHILE statement [T-SQL] |
| control statements: Transact-SQL IF statement | IF statement [T-SQL] |
| control statements: Transact-SQL WHILE statement | WHILE statement [T-SQL] |
| control statements: WHILE SQL statement | LOOP statement |
| conventions: documentation | SQL Anywhere Studio documentation |
| conventions: SQL language syntax | Keywords |
| conversion functions: alphabetical list | Data type conversion functions |
| conversion functions: data type | Data type conversion functions |
| conversion: strings to dates | Transact-SQL compatibility of string-to-date/time conversions |
| CONVERT function: data type conversions | Data type conversions |
| CONVERT function: SQL syntax | CONVERT function [Data type conversion] |
| converting ambiguous dates | Ambiguous string to date conversions |
| converting strings: about | String functions |
| copyright: retrieving | xp_msver system procedure |
| correlation names: in the DELETE statement | DELETE statement |
| COS function: SQL syntax | COS function [Numeric] |
| cost model: calibrating the server | ALTER DATABASE statement |
| cost model: recalibrating | ALTER DATABASE statement |
| COT function: SQL syntax | COT function [Numeric] |
| COUNT function: SQL syntax | COUNT function [Aggregate] |
| CREATE COMPRESSED DATABASE statement: SQL syntax | CREATE COMPRESSED DATABASE statement |
| CREATE DATABASE statement: SQL syntax | CREATE DATABASE statement |
| CREATE DATATYPE statement: SQL syntax | CREATE DOMAIN statement |
| CREATE DBSPACE statement: SQL syntax | CREATE DBSPACE statement |
| CREATE DECRYPTED FILE statement: SQL syntax | CREATE DECRYPTED FILE statement |
| CREATE DOMAIN statement: SQL syntax | CREATE DOMAIN statement |
| CREATE DOMAIN statement: using | Domains |
| CREATE ENCRYPTED FILE statement: SQL syntax | CREATE ENCRYPTED FILE statement |
| CREATE EVENT statement: SQL syntax | CREATE EVENT statement |
| CREATE EXISTING TABLE statement: proxy tables | sp_remote_columns system procedure sp_remote_tables system procedure |
| CREATE EXISTING TABLE statement: SQL syntax | CREATE EXISTING TABLE statement |
| CREATE EXPANDED DATABASE statement: SQL syntax | CREATE COMPRESSED DATABASE statement |
| CREATE EXTERNLOGIN statement: SQL syntax | CREATE EXTERNLOGIN statement |
| CREATE FUNCTION statement: SQL syntax | CREATE FUNCTION statement |
| CREATE FUNCTION statement: Transact-SQL example | CREATE FUNCTION statement |
| CREATE INDEX statement: SQL syntax | CREATE INDEX statement |
| CREATE INDEX statement: table use | CREATE INDEX statement |
| CREATE MESSAGE statement: Transact-SQL syntax | CREATE MESSAGE statement [T-SQL] |
| CREATE PROCEDURE statement: SQL syntax | CREATE PROCEDURE statement |
| CREATE PROCEDURE statement: Transact-SQL syntax | CREATE PROCEDURE statement [T-SQL] |
| CREATE PUBLICATION statement: SQL syntax | CREATE PUBLICATION statement |
| CREATE REMOTE MESSAGE TYPE statement: SQL syntax | CREATE REMOTE MESSAGE TYPE statement [SQL Remote] |
| CREATE SCHEMA statement: SQL syntax | CREATE SCHEMA statement |
| CREATE SERVER statement: SQL syntax | CREATE SERVER statement |
| CREATE SERVICE statement: SQL syntax | CREATE SERVICE statement |
| CREATE STATISTICS statement: SQL syntax | CREATE STATISTICS statement |
| CREATE SUBSCRIPTION statement: SQL syntax | CREATE SUBSCRIPTION statement [SQL Remote] |
| CREATE SYNCHRONIZATION SUBSCRIPTION statement: SQL syntax | CREATE SYNCHRONIZATION SUBSCRIPTION statement [MobiLink] |
| CREATE SYNCHRONIZATION USER statement: SQL syntax | CREATE SYNCHRONIZATION USER statement [MobiLink] |
| CREATE TABLE statement: remote tables | CREATE TABLE statement |
| CREATE TABLE statement: SQL syntax | CREATE TABLE statement |
| CREATE TABLE statement: Transact-SQL | CREATE TABLE statement |
| CREATE TRIGGER statement: SQL syntax | CREATE TRIGGER statement CREATE TRIGGER statement [SQL Remote] |
| CREATE TRIGGER statement: Transact-SQL syntax | CREATE TRIGGER statement [T-SQL] |
| CREATE VARIABLE statement: SQL syntax | CREATE VARIABLE statement |
| CREATE VIEW statement: SQL syntax | CREATE VIEW statement |
| CREATE WRITEFILE statement: SQL syntax | CREATE WRITEFILE statement |
| creating: backups of databases | BACKUP statement |
| creating: compressed databases | CREATE COMPRESSED DATABASE statement |
| creating: cursors | DECLARE CURSOR statement [ESQL] [SP] |
| creating: cursors in Transact-SQL | DECLARE CURSOR statement [T-SQL] |
| creating: data types | Domains |
| creating: database files | CREATE DBSPACE statement |
| creating: databases | CREATE DATABASE statement |
| creating: domains | Domains CREATE DOMAIN statement |
| creating: functions | CREATE FUNCTION statement |
| creating: indexes | CREATE INDEX statement |
| creating: local temporary tables | DECLARE LOCAL TEMPORARY TABLE statement |
| creating: messages | CREATE MESSAGE statement [T-SQL] |
| creating: proxy tables | CREATE EXISTING TABLE statement CREATE TABLE statement sp_remote_tables system procedure |
| creating: publications | CREATE PUBLICATION statement |
| creating: remote message types | CREATE REMOTE MESSAGE TYPE statement [SQL Remote] |
| creating: savepoints | SAVEPOINT statement |
| creating: schemas | CREATE SCHEMA statement |
| creating: servers | CREATE SERVER statement |
| creating: SQL variables | CREATE VARIABLE statement DECLARE statement |
| creating: stored procedures | CREATE PROCEDURE statement |
| creating: stored procedures in Transact SQL | CREATE PROCEDURE statement [T-SQL] |
| creating: subscriptions | CREATE SUBSCRIPTION statement [SQL Remote] |
| creating: tables | CREATE TABLE statement |
| creating: triggers | CREATE TRIGGER statement CREATE TRIGGER statement [SQL Remote] |
| creating: triggers in Transact-SQL | CREATE TRIGGER statement [T-SQL] |
| creating: views | CREATE VIEW statement |
| creating: web services | CREATE SERVICE statement |
| creating: write files | CREATE WRITEFILE statement |
| CROSS JOIN: SQL syntax | FROM clause |
| CSCONVERT function: SQL syntax | CSCONVERT function [STRING] |
| CURRENT DATABASE: special value | CURRENT DATABASE special value |
| CURRENT DATE: special value | CURRENT DATE special value |
| CURRENT PUBLISHER | GRANT PUBLISH statement [SQL Remote] |
| CURRENT PUBLISHER: special value | CURRENT PUBLISHER special value |
| CURRENT TIME: special value | CURRENT TIME special value |
| CURRENT TIMESTAMP: special value | CURRENT TIMESTAMP special value |
| CURRENT USER: special value | CURRENT USER special value |
| CURRENT UTC TIMESTAMP: special value | CURRENT UTC TIMESTAMP special value |
| cursors: closing | CLOSE statement [ESQL] [SP] |
| cursors: deallocating | DEALLOCATE statement |
| cursors: declaring | DECLARE CURSOR statement [ESQL] [SP] |
| cursors: declaring in Transact-SQL | DECLARE CURSOR statement [T-SQL] |
| cursors: deleting rows from | DELETE (positioned) statement [ESQL] [SP] |
| cursors: describing | DESCRIBE statement [ESQL] |
| cursors: describing behavior | CREATE PROCEDURE statement |
| cursors: EXPLAIN statement syntax | EXPLAIN statement [ESQL] |
| cursors: fetching rows from | FETCH statement [ESQL] [SP] |
| cursors: inserting rows using | PUT statement [ESQL] |
| cursors: looping over | FOR statement |
| cursors: opening | OPEN statement [ESQL] [SP] |
| cursors: preparing statements | PREPARE statement [ESQL] |
| cursors: redescribing | CREATE PROCEDURE statement |
| cursors: updatability set in SELECT statement | SELECT statement |
| curunreservedpgs Adaptive Server Enterprise function | System functions |