| RAISERROR statement: ON EXCEPTION RESUME | Transact-SQL-like error handling in the Watcom-SQL dialect |
| RAISERROR statement: Transact-SQL | Using the RAISERROR statement in procedures |
| range queries | Using ranges (between and not between) in the WHERE clause |
| RAW mode: using | Using FOR XML RAW |
| read locks | Types of locks Locking during deletes |
| reading access plans | Reading access plans |
| reading entity-relationship diagrams | Relationships |
| reading the access plan: key statistics | Graphical plans |
| rebuild file formats | Rebuild file formats |
| rebuild tools | Rebuild tools |
| rebuilding | Reloading a Database |
| rebuilding databases: about | Rebuilding databases |
| rebuilding: databases | Rebuilding a database not involved in replication |
| rebuilding: minimizing downtime | Minimizing downtime during rebuilding |
| rebuilding: purpose | Rebuild file formats |
| rebuilding: replicating databases | Rebuilding a database involved in replication |
| rebuilding: tools | Rebuild tools |
| recommendations: Index Consultant | Understanding the recommendations |
| recommended page sizes | Recommended page sizes |
| recursive queries: restrictions | Restrictions on recursive common table expressions |
| recursive subqueries: about | Common Table Expressions |
| recursive subqueries: datatype declarations in | Datatype declarations in recursive common table expressions |
| recursive subqueries: least distance problems | Least distance problem |
| recursive subqueries: multiple aggregation levels | Typical applications of common table expressions |
| recursive subqueries: parts explosion problems | Parts explosion problems |
| recursive tables: algorithm | Recursive table |
| redirecting: output to files | Exporting query results |
| reduce the number of requests between client and server | Reduce the number of requests between client and server |
| reducing the impact of locking | Reducing the impact of locking |
| references: displaying references from other tables | Managing foreign keys (Sybase Central) |
| referential integrity | Adaptive Server Anywhere SQL features |
| referential integrity actions: implemented by system triggers | Referential integrity actions |
| referential integrity: about | Data integrity overview |
| referential integrity: actions | Referential integrity actions |
| referential integrity: breached by client application | If a client application breaches referential integrity |
| referential integrity: checking | Referential integrity checking |
| referential integrity: column defaults | Using column defaults |
| referential integrity: constraints | SQL statements for implementing integrity constraints Using table and column constraints |
| referential integrity: enforcing | Enforcing entity and referential integrity |
| referential integrity: information in the system tables | Integrity rules in the system tables |
| referential integrity: introduction | Data integrity tools |
| referential integrity: losing | Losing referential integrity |
| referential integrity: orphans | Locking during inserts |
| referential integrity: tools | Data integrity tools |
| referential integrity: verification at commit | Locking during inserts |
| reflexive relationships | Relationships |
| relationships: about | Relationships |
| relationships: cardinality of | Relationships |
| relationships: changing to an entity | Changing many-to-many relationships into entities |
| relationships: choosing | Step 1: Identify entities and relationships |
| relationships: definition of | Database design concepts |
| relationships: mandatory versus optional | Relationships |
| relationships: many-to-many | Relationships |
| relationships: one-to-many | Relationships |
| relationships: one-to-one | Relationships |
| relationships: reflexive | Relationships |
| relationships: resolving | Step 4: Resolve the relationships |
| relationships: roles | Relationships |
| relative benefit: Index Consultant recommendations | Understanding the recommendations |
| reloading databases: about | Rebuilding databases |
| reloading: databases | Reloading a Database |
| remember to delimit statements within your procedure | Remember to delimit statements within your procedure |
| remote data access: about | Accessing Remote Data |
| remote data access: case sensitivity | Case sensitivity |
| remote data access: connection names | Managing remote data access connections |
| remote data access: internal operations | Internal operations |
| remote data access: introduction | Introduction |
| remote data access: passthrough mode | Sending native statements to remote servers |
| remote data access: performance limitations | Introduction |
| remote data access: PowerBuilder DataWindows | Accessing remote data from PowerBuilder DataWindows |
| remote data access: remote servers | Working with remote servers |
| remote data access: SQL Remote unsupported | Features not supported for remote data |
| remote data access: troubleshooting | Troubleshooting remote data access |
| remote data access: unsupported features | Features not supported for remote data |
| remote data: location | Specifying proxy table locations |
| remote databases: replication | Replication and concurrency |
| remote procedure calls: about | Using remote procedure calls (RPCs) |
| remote procedure creation wizard: using | Creating remote procedures Creating procedures |
| remote procedures: adding | Creating remote procedures |
| remote procedures: calls | Using remote procedure calls (RPCs) |
| remote procedures: creating | Creating procedures |
| remote procedures: data types | Creating remote procedures |
| remote procedures: deleting | Dropping remote procedures |
| remote server creation wizard: using | Creating remote servers using Sybase Central |
| remote servers: about | Working with remote servers |
| remote servers: altering | Altering remote servers |
| remote servers: classes | Server Classes for Remote Data Access Overview |
| remote servers: creating | Creating remote servers |
| remote servers: deleting | Deleting remote servers |
| remote servers: external logins | Working with external logins |
| remote servers: listing properties | Listing remote server capabilities |
| remote servers: transaction management | Transaction management and remote data |
| remote table mappings | Remote table mappings |
| remote tables: about | Remote table mappings |
| remote tables: accessing | Accessing Remote Data |
| remote tables: listing | Listing the remote tables on a server |
| remote tables: listing columns | Listing the columns on a remote table |
| remote transaction management overview | Remote transaction management overview |
| renaming columns in query results | Renaming columns in query results |
| repeatable reads | Typical types of inconsistency Non-repeatable read tutorial Locking during queries |
| replication and concurrency | Replication and concurrency |
| replication: concurrency | Replication and concurrency |
| replication: concurrency issues | Particular concurrency issues |
| replication: rebuilding databases | Rebuilding databases Rebuilding a database involved in replication |
| requests tab: Index Consultant recommendations | Understanding the recommendations |
| requests: reducing number of | Reduce the number of requests between client and server |
| requirements for using the debugger | Requirements for using the debugger |
| reserved words: remote servers | Features not supported for remote data |
| resetting procedure profiling: SQL | Resetting procedure profiling |
| resetting procedure profiling: Sybase Central | Resetting procedure profiling |
| RESIGNAL statement: about | Using exception handlers in procedures and triggers |
| resolving: relationships | Step 4: Resolve the relationships |
| RESTRICT action: about | Referential integrity actions |
| restrictions on transaction management | Restrictions on transaction management |
| restrictions: remote data access | Features not supported for remote data |
| result sets: limiting the number of rows | Explicitly limiting the number of rows returned by a query |
| result sets: multiple | Returning multiple result sets from procedures |
| result sets: permissions | Returning result sets from procedures |
| result sets: procedures | Returning procedure results in result sets Returning result sets from procedures |
| result sets: Transact-SQL | Returning result sets from Transact-SQL procedures |
| result sets: variable | Returning variable result sets from procedures |
| retrieving the first few rows of a query | Explicitly limiting the number of rows returned by a query |
| RETURN statement: about | Returning a value using the RETURN statement |
| return types: external functions | Passing parameters to external functions |
| return values: procedures | Error handling in Transact-SQL procedures |
| returning a value using the RETURN statement | Returning a value using the RETURN statement |
| returning multiple result sets from procedures | Returning multiple result sets from procedures |
| returning procedure results in parameters | Returning procedure results in parameters |
| returning procedure results in result sets | Returning procedure results in result sets |
| returning result sets from procedures | Returning result sets from procedures |
| returning result sets from Transact-SQL procedures | Returning result sets from Transact-SQL procedures |
| returning results as procedure parameters | Returning results as procedure parameters |
| returning results from procedures | Returning results from procedures |
| returning variable result sets from procedures | Returning variable result sets from procedures |
| REVOKE statement: and concurrency | Data definition statements and concurrency |
| REVOKE statement: Transact-SQL | Users and groups |
| rewrite optimization: about | Types of semantic transformations |
| rewriting subqueries as EXISTS predicates | Rewriting subqueries as EXISTS predicates |
| right outer joins: about | Outer joins |
| role names: about | Key joins when there are multiple foreign key relationships |
| role of the optimizer | The role of the optimizer |
| roles: Adaptive Server Enterprise | Administrative roles |
| roles: definition of | Relationships |
| rollback logs: savepoints | Savepoints within transactions |
| ROLLBACK statement: compound statements | Atomic compound statements |
| ROLLBACK statement: procedures and triggers | Transactions and savepoints in procedures and triggers |
| ROLLBACK statement: triggers | Transact-SQL trigger overview |
| rolling back transactions | Using transactions |
| ROLLUP operation: about | The ROLLUP operation: adding summary information to GROUP BY queries |
| ROLLUP operation: example | The ROLLUP operation: adding summary information to GROUP BY queries |
| ROLLUP operation: NULL | The ROLLUP operation: adding summary information to GROUP BY queries |
| ROLLUP operation: subtotal rows | The ROLLUP operation: adding summary information to GROUP BY queries |
| ROLLUP operation: understanding GROUP BY | How queries with GROUP BY are executed |
| row limit count: item in access plans | Reading access plans |
| row limits: query execution algorithms | Row limit |
| rows: copying with INSERT | Adding new rows with SELECT |
| rows: deleting | Disk allocation for inserted rows |
| rows: selecting | The WHERE clause: specifying rows |
| RowsReturned: statistic in access plans | Reading access plans |
| rules describing the operation of key joins | Rules describing the operation of key joins |
| rules: Transact-SQL | Defaults and rules |
| running: command files | Running SQL command files |
| running: SQL scripts | Running SQL command files Saving, loading, and running command files |
| RunTime: statistic in access plans | Reading access plans |