| cache buffers : and performance | - c command-line option |
| cache size : setting | - c command-line option |
| CacheHits property | Properties available for the server |
| CacheRead property | Connection properties Properties available for the server |
| CacheReadIndInt property | Connection properties Properties available for the server |
| CacheReadIndLeaf property | Connection properties Properties available for the server |
| CacheReadTable property | Connection properties Properties available for the server |
| CacheWrite property | Connection properties Properties available for the server |
| CALL statement : syntax | CALL statement |
| CALL statement : Transact-SQL | EXECUTE statement [T-SQL] |
| CASCADE | CREATE TABLE statement |
| CASE expression | CASE expressions |
| CASE expression : NULLIF function | NULLIF function [Miscellaneous] |
| case sensititivy : connection parameters | Connection parameters |
| case sensitivity | The DBINIT command-line utility |
| case sensitivity : and pattern matching | LIKE conditions |
| case sensitivity : comparison conditions | Comparison conditions |
| case sensitivity : in the catalog | SYSINFO system table |
| case sensitivity : of Java data types | Case sensitivity of Java class data types |
| CASE statement : syntax | CASE statement |
| CAST function | Data type conversions CAST function [Data type conversion] |
| CAStop connection parameter | CommAutoStop connection parameter [CAstop] |
| catalog : diagram | System tables diagram |
| catalog : system tables | CHAPTER 15. System Tables |
| catalog : system tables list | System table descriptions |
| Catalog procedures : list | System and catalog stored procedures |
| catalog procedures : sp_columns | Adaptive Server Enterprise catalog procedures |
| catalog procedures : sp_column_privileges | Adaptive Server Enterprise catalog procedures |
| catalog procedures : sp_fkeys | Adaptive Server Enterprise catalog procedures |
| catalog procedures : sp_pkeys | Adaptive Server Enterprise catalog procedures |
| catalog procedures : sp_special_columns | Adaptive Server Enterprise catalog procedures |
| catalog procedures : sp_sproc_columns | Adaptive Server Enterprise catalog procedures |
| catalog procedures : sp_stored_procedures | Adaptive Server Enterprise catalog procedures |
| catalog procedures : sp_tables | Adaptive Server Enterprise catalog procedures |
| catalog procedures : Transact-SQL list | Adaptive Server Enterprise system and catalog procedures |
| catalog procedures : Transact-SQL, list | Adaptive Server Enterprise catalog procedures |
| CBSize connection parameter | CommBufferSize connection parameter [CBSize] |
| CBSpace connection parameter | CommBufferSpace connection parameter [CBSpace] |
| CEILING function | CEILING function [Numeric] |
| century issues | Year 2000 compliance |
| CHAINED option | CHAINED option |
| chained transaction mode | CHAINED option BEGIN TRANSACTION statement |
| CHAR data type : about | CHAR data type [Character] |
| CHAR data type : and host variables | ANSI_BLANKS option |
| CHAR function | CHAR function [String] |
| character set translation : enabling | -ct command-line option |
| character sets : storage | Character data types |
| character strings | The SQL preprocessor |
| CHARACTER VARYING data type : about | CHARACTER VARYING data type [Character] |
| CHARINDEX function | CHARINDEX function [String] |
| CHAR_LENGTH function | CHAR_LENGTH function [String] |
| CHAR_OEM_TRANSLATION option | CHAR_OEM_TRANSLATION option [ISQL |
| CHECK conditions : about | CREATE TABLE statement |
| CHECK ON COMMIT clause : referential integrity | CREATE TABLE statement |
| checkpoint log CHECKPOINT statement | CHECKPOINT statement |
| CHECKPOINT statement : syntax | CHECKPOINT statement |
| checkpoints : CHECKPOINT_TIME option | CHECKPOINT_TIME option CHECKPOINT_TIME option |
| checkpoints : interval between | -gc command-line option |
| CHECKPOINT_TIME option | General database options CHECKPOINT_TIME option |
| Chkpt property | Properties available for the server |
| ChkptFlush property | Properties available for the server |
| ChkptPage property | Properties available for the server |
| classes : installing | INSTALL statement |
| classes : Java methods | Java and SQL user-defined functions |
| classes : removing | REMOVE statement |
| classes : supported | Built-in Java classes |
| classes : unsupported | Unsupported packages and classes |
| CLEAR statement : syntax | CLEAR statement [ISQL] |
| CLIB.NLM | The database server |
| client : command line | The client compatibility executable |
| CLOSE statement : syntax | CLOSE statement [ESQL] [SP] |
| CLOSE_ON_ENDTRANS option | CLOSE_ON_ENDTRANS option |
| COALESCE function | COALESCE function [Miscellaneous] |
| code pages : and data storage | Character data types |
| code pages : CREATE DATABASE statement | CREATE DATABASE statement |
| code pages : list | Initialization utility options |
| Code pages : SYSCOLLATION system table | SYSCOLLATION system table |
| collation sequences | The DBCOLLAT command-line utility |
| collation sequences : and pattern matching | LIKE conditions |
| collation sequences : CREATE DATABASE statement | CREATE DATABASE statement |
| collation sequences : list | Initialization utility options |
| Collation sequences : SYSCOLLATION system table | SYSCOLLATION system table |
| collation sequences : utility | The Collation utility |
| column long names | DESCRIBE statement [ESQL] |
| columns : aliases | SELECT statement |
| columns : altering | ALTER TABLE statement |
| columns : and user-defined data types | User-defined data types |
| columns : changing heading name | SELECT statement |
| columns : constraints | User-defined data types CREATE TABLE statement |
| columns : in the system tables | SYSCOLUMN system table |
| columns : naming | Statement elements Column names in expressions |
| columns : permissions on | SYSCOLPERM system table |
| columns : renaming | ALTER TABLE statement |
| columns : SYSCOLUMNS system view | SYSCOLUMNS system view |
| col_length Adaptive Server Enterprise function | Connection properties |
| col_name Adaptive Server Enterprise function | Connection properties |
| comma delimited files | INPUT_FORMAT option [ISQL OUTPUT_FORMAT option [ISQL |
| command delimiter : setting | COMMAND_DELIMITER option [ISQL |
| command echo | ECHO option [ISQL |
| command files : about | READ statement [ISQL] |
| command files : parameters | PARAMETERS statement [ISQL] |
| command line : client | The client compatibility executable |
| command line : database server | The database server |
| command line : in configuration file | @filename command-line option |
| command line : server | @filename command-line option |
| command line : switches | @filename command-line option The client compatibility executable |
| command line utilities and Unix | Administration utilities overview |
| command-line options : dbping | The DBPing utility |
| CommAutoStop connection parameter | CommAutoStop connection parameter [CAstop] |
| CommBufferSize connection parameter | CommBufferSize connection parameter [CBSize] |
| CommBufferSpace connection parameter | CommBufferSpace connection parameter [CBSpace] |
| COMMENT statement : syntax | COMMENT statement |
| comments : about | SQL comments |
| comments : comment delimiters | PERCENT_AS_COMMENT option |
| comments : comment indicators | SQL comments |
| Commit property | Connection properties |
| COMMIT statement : syntax | COMMIT statement |
| COMMIT TRANSACTION statement : Transact-SQL | COMMIT TRANSACTION statement [T-SQL] |
| CommitFile property | Properties available for the server |
| commits : COOPERATIVE_COMMITS option | COOPERATIVE_COMMITS option |
| commits : COOPERATIVE_COMMIT_TIMEOUT option | COOPERATIVE_COMMIT_TIMEOUT option |
| commits : DELAYED_COMMITS option | DELAYED_COMMITS option |
| commits : DELAYED_COMMIT_TIMEOUT option | DELAYED_COMMIT_TIMEOUT option |
| COMMIT_ON_EXIT : Interactive SQL option | COMMIT_ON_EXIT option [ISQL |
| CommLink property | Connection properties |
| CommLinks connection parameter | CommLinks connection parameter [Links] |
| communication parameters : about | CHAPTER 3. Connection and Communication Parameters |
| communication parameters : BROADCAST | BROADCAST parameter [BCAST] |
| communication parameters : DLL | DLL parameter |
| communication parameters : DOBROADCAST | DOBROADCAST parameter |
| communication parameters : EXTENDEDNAME | EXTENDEDNAME parameter |
| communication parameters : HOST | HOST parameter [IP] |
| communication parameters : MAXLANA | MAXLANA parameter |
| communication parameters : MYIP | MYIP parameter |
| communication parameters : REGISTERBINDERY | REGISTERBINDERY parameter [ REGBIN] |
| communication parameters : SEARCHBINDERY | SEARCHBINDERY parameter [BINSEARCH] |
| communication parameters : ServerPort | SERVERPORT parameter [ PORT] |
| communication parameters : SESSIONS | SESSIONS parameter |
| communication parameters : TDS | TDS parameter |
| communication parameters : THREADS | THREADS parameter |
| communication parameters : THREADSTATS | THREADSTATS parameter [STATS] |
| communication parameters : TIMEOUT | TIMEOUT parameter [TO] |
| communication parameters : WSAVERSION | WSAVERSION parameter [WSAVER] |
| communications : database server | - x command-line option |
| communications : debugging | - z command-line option |
| communications : parameters | Network communications parameters |
| CompanyName property | Properties available for the server |
| comparing dates and times | Date and time comparisons |
| comparisons : about | Search conditions |
| compatibility : QUERY_PLAN_ON_OPEN | QUERY_PLAN_ON_OPEN option |
| compound statements | BEGIN... END statement |
| compound statements : about | BEGIN... END statement |
| compressed databases | The DBEXPAND command-line utility |
| compression utility | The Compression utility |
| concatenating strings | String operators |
| conditions : about | Search conditions |
| configuration file : for the LTM | The LTM configuration file |
| configuration file : LTM command line | The Log Transfer Manager |
| configuration file : switch | @filename command-line option |
| CONFIGURE statement : syntax | CONFIGURE statement [ISQL] |
| ConnCount property | Properties available for each database |
| CONNECT statement : syntax | CONNECT statement [ESQL] [ISQL] |
| connection parameters : about | CHAPTER 3. Connection and Communication Parameters |
| connection parameters : case insensitivity | Connection parameters |
| connection parameters : overview | Connection parameters |
| connection properties : displaying | System and catalog stored procedures |
| connection-level variables : about | Connection-level variables |
| ConnectionName connection parameter | ConnectionName connection parameter [CON] |
| connections : dropping | -ta command-line option -ti command-line option -tl command-line option |
| connections : Interactive SQL | DISCONNECT statement [ESQL][ISQL] |
| connections : limit | -gm command-line option |
| connections : liveness | -tl command-line option |
| connections : parameters | CHAPTER 3. Connection and Communication Parameters |
| connections : pooling | SETUSER statement |
| connections : properties of | Connection properties |
| CONNECTION_PROPERTY function | CONNECTION_PROPERTY function [System] |
| connection_property function : about | Finding option settings Obtaining database statistics from a client application |
| console utility : command line | The Console utility |
| constants : in expressions | 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 | WHILE statement [T-SQL] |
| CONTINUE_AFTER_RAISE_ERROR option | CONTINUE_AFTER_RAISE_ERROR option |
| ContReq property | Properties available for the server |
| control statements : CALL statement | CALL statement |
| control statements : CASE statement | CASE statement |
| control statements : IF statement | IF statement |
| control statements : LEAVE statement | LEAVE statement |
| control statements : LOOP 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 GOTO statement | GOTO 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 statement | LOOP statement |
| conventions : documentation | Documentation conventions |
| CONVERSION_ERROR option | Transact-SQLcompatibility options CONVERSION_ERROR option |
| CONVERT FUNCTION | Data type conversions |
| CONVERT function | CONVERT function [Data type conversion] |
| converting ambiguous dates | Ambiguous string to date conversions |
| COOPERATIVE_COMMITS option | General database options COOPERATIVE_COMMITS option |
| COOPERATIVE_COMMIT_TIMEOUT option | General database options COOPERATIVE_COMMIT_TIMEOUT option |
| copyright : retrieving | xp_msver system function |
| correlation names : in the DELETE statement | DELETE statement |
| COS function | COS function [Numeric] |
| COT function | COT function [Numeric] |
| COUNT function | COUNT function [Aggregate] |
| CREATE COMPRESSED DATABASE statement : syntax | CREATE COMPRESSED DATABASE statement |
| CREATE DATABASE statement : syntax | CREATE DATABASE statement |
| CREATE DATATYPE statement : syntax | CREATE DOMAIN statement |
| CREATE DBSPACE statement : syntax | CREATE DBSPACE statement |
| CREATE DOMAIN statement : syntax | CREATE DOMAIN statement |
| CREATE DOMAIN statement : using | User-defined data types |
| CREATE EXISTING TABLE statement : proxy tables | CREATE EXISTING TABLE statement DROP EXTERNLOGIN statement |
| create existing table statement : proxy tables | DROP SERVER statement sp_remote_columns system procedure sp_remote_tables system procedure |
| CREATE EXPANDED DATABASE statement : syntax | CREATE COMPRESSED DATABASE statement |
| CREATE EXTERNLOGIN statement : syntax | CREATE EXTERNLOGIN statement |
| CREATE FUNCTION statement : syntax | CREATE FUNCTION statement |
| CREATE INDEX statement : syntax | CREATE INDEX statement |
| CREATE INDEX statement : table use | CREATE INDEX statement |
| CREATE MESSAGE statement : Transact-SQL | CREATE MESSAGE statement [T-SQL] |
| CREATE PROCEDURE statement : syntax | CREATE PROCEDURE statement |
| CREATE PROCEDURE statement : Transact-SQL | CREATE PROCEDURE statement [T-SQL] |
| CREATE SCHEMA statement : syntax | CREATE SCHEMA statement |
| CREATE SERVER statement : syntax | CREATE SERVER statement |
| CREATE TABLE : Java classes | Using classes as data types |
| CREATE TABLE statement : examples | CHAPTER 15. System Tables |
| CREATE TABLE statement : remote tables | CREATE TABLE statement |
| CREATE TABLE statement : syntax | CREATE TABLE statement |
| CREATE TABLE statement : Transact-SQL | CREATE TABLE statement |
| CREATE TRIGGER statement : syntax | CREATE TRIGGER statement |
| CREATE TRIGGER statement : Transact-SQL | CREATE TRIGGER statement [T-SQL] |
| CREATE VARIABLE statement : syntax | CREATE VARIABLE statement |
| CREATE VIEW statement : examples | CHAPTER 16. System Views |
| CREATE VIEW statement : syntax | CREATE VIEW statement |
| CREATE WRITEFILE statement : syntax | CREATE WRITEFILE statement |
| creating : data types | User-defined data types CREATE DOMAIN statement |
| creating : databases | The DBINIT command-line utility |
| creating : proxy tables | CREATE EXISTING TABLE statement CREATE TABLE statement |
| Creating : proxy tables | CREATE EXTERNLOGIN statement DROP SERVER statement sp_remote_tables system procedure |
| creating : stored procedures | CREATE PROCEDURE statement |
| creator | Statement elements |
| CROSS JOIN syntax | FROM clause |
| CURRENT DATE default | Constants in expressions |
| CURRENT DATE special constant | Constants in expressions |
| CURRENT PUBLISHER | Constants in expressions Constants in expressions |
| CURRENT TIME default | Constants in expressions |
| CURRENT TIME special constant | Constants in expressions |
| CURRENT TIMESTAMP default | Constants in expressions |
| CURRENT TIMESTAMP special constant | Constants in expressions |
| CURRENT USER : default | Constants in expressions |
| CURRENT USER : environment settings | Current user and local machine settings |
| CURRENT USER : special constant | Constants in expressions |
| CurrIO property | Properties available for the server |
| CurrRead property | Properties available for the server |
| CurrTaskSwitch property | Connection properties |
| CurrWrite property | Properties available for the server |
| CursorOpen property | Connection properties |
| cursors : and transactions | CLOSE_ON_ENDTRANS option |
| cursors : closing | CLOSE_ON_ENDTRANS option CLOSE statement [ESQL] [SP] |
| cursors : connection limits | MAX_CURSOR_COUNT option |
| cursors : database options | Duration of options |
| cursors : declaring | DECLARE CURSOR statement [ESQL] [SP] DECLARE CURSOR statement [T-SQL] |
| cursors : DESCRIBE | DESCRIBE statement [ESQL] |
| cursors : EXPLAIN statement | EXPLAIN statement [ESQL] |
| cursors : fetching | FETCH statement [ESQL] [SP] |
| cursors : looping over | FOR statement |
| cursors : OPEN statement | OPEN statement [ESQL] [SP] |
| cursors : opening | QUERY_PLAN_ON_OPEN option |
| cursors : PUT statement | PUT statement [ESQL] [SP] |
| cursors : ROLLBACK | ANSI_CLOSE_CURSORS_ON_ROLLBACK option |
| cursors : types | DECLARE CURSOR statement [ESQL] [SP] |
| Cursors property | Connection properties |
| curunreservedpgs Adaptive Server Enterprise function | Connection properties |