| data consistency: assuring using locks | How locking works |
| data consistency: correctness | Serializable schedules |
| data consistency: dirty reads | Typical types of inconsistency Locking during queries |
| data consistency: dirty reads tutorial | Dirty read tutorial |
| data consistency: ISO SQL/92 standard | Typical types of inconsistency |
| data consistency: phantom rows | Typical types of inconsistency Phantom row tutorial Locking during queries Two-phase locking |
| data consistency: practical locking implications | Practical locking implications tutorial |
| data consistency: repeatable reads | Typical types of inconsistency Non-repeatable read tutorial Locking during queries |
| data consistency: two-phase locking | Two-phase locking |
| data definition language: about | Introduction |
| data definition statements: and concurrency | Data definition statements and concurrency |
| data definition: concurrency | Particular concurrency issues |
| data entry: and isolation levels | Typical transactions at various isolation levels |
| data formats: for importing and exporting | Data formats |
| data integrity: about | Data integrity overview |
| data integrity: checking | Referential integrity checking |
| data integrity: column constraints | Choosing constraints |
| data integrity: column defaults | Using column defaults |
| data integrity: constraints | SQL statements for implementing integrity constraints Using table and column constraints |
| data integrity: effects of unserializable schedules on | Serializable schedules |
| data integrity: enforcing | Enforcing entity and referential integrity |
| data integrity: information in the system tables | Integrity rules in the system tables |
| data integrity: losing | Losing referential integrity |
| data integrity: tools | Data integrity tools |
| data migration wizard: about | Migrating databases to Adaptive Server Anywhere |
| data migration wizard: using | Migrating databases to Adaptive Server Anywhere |
| data model normalization | Step 3: Normalize the data |
| data modeling: about | Designing Your Database |
| data modification statements: about | Data modification statements |
| data organization: physical | Physical data organization and access |
| data sources: external servers | Defining ODBC external servers |
| data types: aggregate functions | Aggregate functions and data types |
| data types: assigning columns | Creating domains (Sybase Central) |
| data types: choosing | Choosing data types for columns |
| data types: creating | Creating domains (Sybase Central) Creating domains (SQL) |
| data types: deleting | Deleting domains |
| data types: EXCEPT operation | Performing set operations on query results with UNION, INTERSECT, and EXCEPT |
| data types: INTERSECT operation | Performing set operations on query results with UNION, INTERSECT, and EXCEPT |
| data types: remote procedures | Creating remote procedures |
| data types: SQL and C | Passing parameters to external functions |
| data types: timestamp | The special Transact-SQL timestamp column and data type |
| data types: UNION operation | Performing set operations on query results with UNION, INTERSECT, and EXCEPT |
| data types: user-defined | Using domains |
| data: exporting as XML | Exporting relational data as XML |
| data: adding, changing, and deleting | Adding, Changing, and Deleting Data |
| data: case sensitivity | Case sensitivity |
| data: consistency | Typical types of inconsistency |
| data: exporting | Export tools |
| data: formats for importing and exporting | Data formats |
| data: importing | Importing and exporting data Importing data |
| data: importing and exporting | Introduction to import and export |
| data: integrity and correctness | Serializable schedules |
| data: invalid | How data can become invalid |
| data: permissions required to modify data | Permissions for data modification |
| data: searching | Use indexes for frequently-searched columns |
| data: viewing | Browsing the information in tables |
| database administrator: roles | Administrative roles |
| database design concepts | Database design concepts |
| database files: fragmentation | Examine file, table, and index fragmentation File fragmentation |
| database files: growing | Rebuild file formats |
| database files: growing after deletes | Rebuild file formats |
| database files: performance | Place different files on different devices |
| database objects: copying in Sybase Central | Copying database objects in Sybase Central |
| database objects: editing properties | Setting properties for database objects |
| database options: Index Consultant | Assessing the recommendations |
| database options: setting for Transact-SQL compatibility | Setting options for Transact-SQL compatibility |
| database pages: Index Consultant recommendations | Understanding the recommendations |
| database procedures: viewing profiling data | Profiling database procedures |
| database statistics: about | Monitoring database statistics from Windows Performance Monitor |
| database threads: blocked | Deadlock |
| databases: case sensitivity | Creating a Transact-SQL-compatible database Case sensitivity |
| databases: creating | Creating a database |
| databases: creating for Windows CE | Creating databases (Sybase Central) |
| databases: creating from SQL | Creating databases (SQL) Erasing a database |
| databases: creating from Sybase Central | Creating databases (Sybase Central) |
| databases: creating from the command line | Creating databases (command line) |
| databases: deleting | Erasing a database |
| databases: design concepts | Database design concepts |
| databases: designing | Designing Your Database |
| databases: disconnecting from databases | Disconnecting from a database |
| databases: displaying system objects | Displaying system objects in a database |
| databases: displaying system tables | Displaying system tables |
| databases: erasing | Erasing a database |
| databases: erasing from the command line | Erasing a database |
| databases: exporting | Exporting databases |
| databases: file compatibility | Creating a database |
| databases: importing | Importing databases |
| databases: importing XML | Importing XML documents as relational data |
| databases: initializing | Creating a database |
| databases: initializing from SQL | Creating databases (SQL) Erasing a database |
| databases: initializing from Sybase Central | Creating databases (Sybase Central) |
| databases: installing jConnect metadata support | Installing the jConnect metadata support to an existing database |
| databases: migrating to Adaptive Server Anywhere | Migrating databases to Adaptive Server Anywhere |
| databases: normalizing | Step 3: Normalize the data |
| databases: rebuilding | Rebuilding a database not involved in replication |
| databases: reloading | Reloading a Database |
| databases: setting a consolidated database | Specifying a consolidated database |
| databases: setting options | Setting database options Setting database options |
| databases: starting without connecting | Starting a database without connecting |
| databases: storing XML | Storing XML documents in relational databases |
| databases: Transact-SQL compatibility | Configuring databases for Transact-SQL compatibility |
| databases: transaction log | Creating a database |
| databases: unloading | Exporting databases |
| databases: unloading and reloading | Rebuilding databases Rebuilding a database not involved in replication Rebuilding a database involved in replication Minimizing downtime during rebuilding |
| databases: upgrading database file format | Rebuild file formats |
| databases: verifying design | Step 5: Verify the design |
| databases: viewing and editing properties | Setting properties for database objects |
| databases: working with | Working with databases |
| databases: working with objects | Working with Database Objects |
| DataSet: using to export relational data as XML | Exporting relational data as XML using the DataSet object |
| DataSet: using to import XML | Importing XML using the DataSet object |
| datatypes: in recursive subqueries | Datatype declarations in recursive common table expressions |
| DataWindows: remote data access | Accessing remote data from PowerBuilder DataWindows |
| dates: entry rules | Character strings and quotation marks |
| dates: procedures and triggers | Specifying dates and times in procedures |
| dates: searching for | Character strings and quotation marks |
| DB2 remote data access | Server class db2odbc |
| db2odbc server class | Server class db2odbc |
| dBASE format for importing and exporting | Data formats |
| dberase utility | Erasing a database |
| dberase utility: using | Erasing a database |
| dbinit utility: using | Creating databases (command line) |
| dbisql utility: rebuilding databases | Rebuild tools |
| dbo user ID: Adaptive Server Enterprise | System tables |
| dbspaces: managing | Device management |
| dbunload utility | Rebuild tools |
| dbunload utility: exporting data | Export tools |
| DB_PROPERTY function: about | Obtaining database statistics from a client application |
| DDL: about | Introduction |
| deadlocks: about | Transaction blocking and deadlock |
| deadlocks: reasons for | Deadlock |
| deadlocks: transaction blocking | Deadlock |
| debugger : displaying source code | Display Java source code in the debugger |
| debugger features | Debugger features |
| debugger utility: features | Debugger features |
| debugger: about | Debugger features |
| debugger: connecting | Lesson 1: Connect to a database and start the debugger |
| debugger: debugging Java classes | Lesson 3: Debug a Java class |
| debugger: debugging stored procedures | Lesson 2: Debug a stored procedure |
| debugger: examining variables | Working with variables |
| debugger: getting started | Lesson 1: Connect to a database and start the debugger |
| debugger: requirements | Requirements for using the debugger |
| debugger: starting | Start the debugger |
| debugger: tutorial | Lesson 1: Connect to a database and start the debugger |
| debugger: working with breakpoints | Working with breakpoints Working with breakpoints |
| debugger: working with connections | Working with connections |
| debugger_tutorial procedure: about | Run the debugger_tutorial procedure |
| debugging logic in the database | Debugging Logic in the Database |
| debugging: about | Debugging Logic in the Database |
| debugging: breakpoints | Step through source code |
| debugging: compiling classes | Lesson 3: Debug a Java class |
| debugging: features | Debugger features |
| debugging: introduction | Introduction to debugging in the database |
| debugging: Java | Lesson 3: Debug a Java class |
| debugging: local variables | Inspect and modify variables |
| debugging: permissions | Requirements for using the debugger |
| debugging: requirements | Requirements for using the debugger |
| debugging: stored procedures | Lesson 2: Debug a stored procedure |
| debugging: tutorial | Lesson 2: Debug a stored procedure Lesson 3: Debug a Java class |
| decision support: and isolation levels | Typical transactions at various isolation levels |
| declarations in compound statements | Declarations in compound statements |
| DECLARE statement: compound statements | Declarations in compound statements |
| DECLARE statement: procedures | Cursor management overview Default error handling in procedures and triggers |
| declaring parameters for procedures | Declaring parameters for procedures |
| default error handling in procedures and triggers | Default error handling in procedures and triggers |
| default handling of warnings in procedures and triggers | Default handling of warnings in procedures and triggers |
| defaults: AUTOINCREMENT | The AUTOINCREMENT default |
| defaults: column | Using column defaults |
| defaults: constant expressions | Constant expression defaults |
| defaults: creating | Creating column defaults |
| defaults: creating in Sybase Central | Working with column defaults in Sybase Central |
| defaults: current date and time | Current date and time defaults |
| defaults: INSERT statement and | Inserting values into specific columns |
| defaults: introduction | Data integrity tools |
| defaults: NEWID | The NEWID default |
| defaults: NULL | The NULL default |
| defaults: string and number | String and number defaults |
| defaults: Transact-SQL | Defaults and rules |
| defaults: user ID | The user ID default |
| defaults: using in domains | Creating domains (SQL) |
| defaults: with transactions and locks | Primary key generation |
| defragmenting: about | Fragmentation |
| defragmenting: all tables in a database | Table fragmentation |
| defragmenting: hard disk | File fragmentation |
| defragmenting: individual tables in a database | Table fragmentation |
| delaying referential integrity checks | Locking during inserts |
| DELETE statement: locking during | Locking during deletes |
| DELETE statement: using | Deleting data using DELETE |
| deleting all rows from a table | Deleting all rows from a table |
| deleting and deleting CHECK constraints | Modifying and deleting CHECK constraints |
| deleting data: about | Adding, Changing, and Deleting Data |
| deleting data: DELETE statement | Deleting data using DELETE |
| deleting data: TRUNCATE TABLE statement | Deleting all rows from a table |
| deleting remote servers | Deleting remote servers |
| deleting: column defaults | Modifying and deleting column defaults |
| deleting: data types | Deleting domains |
| deleting: database files | Erasing a database |
| deleting: domains | Deleting domains |
| deleting: indexes | Dropping indexes |
| deleting: procedures | Deleting procedures |
| deleting: tables | Deleting tables |
| deleting: triggers | Dropping triggers |
| deleting: user-defined data types | Deleting domains |
| deleting: views | Deleting views |
| delimit statements within your procedure | Remember to delimit statements within your procedure |
| depth: item in access plans | Reading access plans |
| derived tables: in joins | Joins involving derived tables |
| derived tables: in key joins | Key joins of views and derived tables |
| derived tables: in natural joins | Natural joins of views and derived tables |
| derived tables: in outer joins | Outer joins of views and derived tables |
| derived tables: using in the FROM clause | The FROM clause: specifying tables |
| descending order: ORDER BY clause | The ORDER BY clause: sorting query results |
| design details pane: about | Logging SQL statements as you work with a database |
| design process | The design process |
| designing databases: about | Designing Your Database |
| designing databases: concepts | Database design concepts |
| designing databases: procedure | The design process |
| designing the database table properties | Designing the database table properties |
| designing your database | Designing Your Database |
| deterministic functions: defined | Subquery and function caching |
| devices: managing | Device management |
| difference between FALSE and UNKNOWN | Properties of NULL |
| differences from other SQL dialects | Differences from Other SQL Dialects |
| directed graphs | Least distance problem |
| direction: item in access plans | Reading access plans |
| dirty reads | Typical types of inconsistency Typical types of inconsistency Locking during queries |
| dirty reads: tutorial | Dirty read tutorial |
| dirty reads: versus isolation levels | Typical types of inconsistency |
| disabling breakpoints | Disabling and enabling breakpoints |
| disabling breakpoints: enabling | Disabling and enabling breakpoints |
| disabling procedure profiling: SQL | Disabling procedure profiling |
| disabling procedure profiling: Sybase Central | Disabling procedure profiling |
| DISCONNECT statement: using | Disconnecting from a database |
| disconnecting: from databases | Disconnecting from a database |
| disconnecting: other users from a database | Disconnecting from a database |
| discovery of exploitable conditions | Discovery of exploitable conditions |
| disk access cost model: about | How the optimizer works |
| disk allocation for inserted rows | Disk allocation for inserted rows |
| disk space: reclaiming | Rebuild file formats |
| DISK statements: unsupported | Device management |
| DiskRead: statistic in access plans | Reading access plans |
| DiskReadIndInt: statistic in access plans | Reading access plans |
| DiskReadIndLeaf: statistic in access plans | Reading access plans |
| DiskReadTable: statistic in access plans | Reading access plans |
| DiskWrite: statistic in access plans | Reading access plans |
| displaying system objects in a database | Displaying system objects in a database |
| displaying system tables | Displaying system tables |
| DISTINCT clause: SELECT statement | Eliminating duplicate query results |
| DISTINCT clause: unnecessary distinct elimination | Unnecessary DISTINCT elimination |
| distinct elimination: about | Unnecessary DISTINCT elimination |
| DISTINCT keyword: aggregate functions | Summarizing query results using aggregate functions Using aggregate functions with DISTINCT |
| distinct list: item in access plans | Reading access plans |
| DLL: calling from procedures | Calling external libraries from procedures |
| DLL: external procedure calls | Creating procedures and functions with external calls |
| DML: about | Data modification statements |
| documentation: conventions | SQL Anywhere Studio documentation |
| documentation: SQL Anywhere Studio | SQL Anywhere Studio documentation |
| documents: inserting | Inserting documents and images |
| domain creation wizard: using | Creating domains (Sybase Central) |
| domains: assigning columns | Creating domains (Sybase Central) |
| domains: case sensitivity | Case sensitivity |
| domains: CHECK constraints | Inheriting column CHECK constraints from domains |
| domains: creating | Creating domains (Sybase Central) Creating domains (SQL) |
| domains: deleting | Deleting domains |
| domains: examples of uses | Using domains |
| domains: using | Using domains |
| double quotes: character strings | Character strings and quotation marks |
| DROP CONNECTION statement: using | Disconnecting from a database |
| DROP DATABASE statement: Adaptive Server Enterprise | Servers and databases |
| DROP DATABASE statement: using | Erasing a database |
| DROP statement: and concurrency | Data definition statements and concurrency |
| DROP TABLE statement: example | Deleting tables |
| DROP TRIGGER statement: about | Dropping triggers |
| DROP VIEW statement: example | Deleting views |
| dropping connections: remote data access | Managing remote data access connections |
| dropping external logins | Dropping external logins |
| dropping remote procedures | Dropping remote procedures |
| dropping: domains | Deleting domains |
| dropping: indexes | Dropping indexes |
| dropping: procedures | Deleting procedures |
| dropping: tables | Deleting tables |
| dropping: triggers | Dropping triggers |
| dropping: views | Deleting views |
| DUMP DATABASE statement: unsupported | Servers and databases |
| DUMP TRANSACTION statement: unsupported | Servers and databases |
| duplicate correlation names in joins (star joins) | Duplicate correlation names in joins (star joins) |
| duplicate elimination: query execution algorithms | Duplicate elimination |
| duplicate results: eliminating | Eliminating duplicate query results |
| duplicate rows: removing with UNION | Combining sets with the UNION operation |
| dynamic cache sizing: about | Using the cache to improve performance |
| dynamic cache sizing: about UNIX | Dynamic cache sizing (UNIX) |
| dynamic cache sizing: about Windows | Dynamic cache sizing (Windows NT/2000/XP, Windows 95/98/Me) |