Contents

Chapter 1: 
 
  • 1.1 Overview
  • 1.2 Starting SQL Manager
  • 1.3 Organization of this Document
  • Chapter 2: 
     
  • 2.1 The File Menu
  • 2.2 The View Menu
  • 2.3 The Object Menu
  • 2.4 The Options Menu
  • 2.5 The Help Menu
  • Chapter 3: 
     
  • 3.1 Importing Files
  • 3.1.1 Caché Import Wizard
  • 3.1.2 Quick Import
  • 3.2 Configure Caché to Save Source Code
  • 3.3 Opening a Class
  • 3.4 Opening a Routine
  • 3.5 Setting Preferences
  • 3.6 Stored Procedures
  • 3.7 Stored Procedures: General Tab
  • 3.8 Using the Link Table Wizard
  • 3.9 Viewing Properties
  • 3.9.1 View Properties: General Tab
  • 3.9.2 Viewing Properties of Stored Procedures
  • Chapter 4: 
     
  • 4.1 Table Properties
  • 4.1.1 Table Properties: General Tab
  • 4.1.2 Table Properties: Indices Tab
  • 4.1.3 Table Properties: Triggers Tab
  • 4.1.4 Table Properties: Constraints Tab
  • 4.1.5 Table Properties: Cached Queries Tab
  • 4.1.6 Table Properties: Execute Query Tab
  • 4.2 Opening a Table
  • 4.3 Rebuilding Indices
  • 4.4 Creating a Table
  • 4.5 Deleting a Table
  • 4.6 Designing a Table
  • 4.7 Exporting a Table
  • Chapter 5: 
     
  • 5.1 View Properties
  • 5.2 Creating Views
  • 5.3 Opening Views
  • 5.4 Deleting Views
  • 5.5 Purging Cached Queries for a View
  • Chapter 6: 
     
  • 6.1 Executing Queries
  • 6.2 Viewing Query Execution Plans
  • 6.2.1 Cached Queries: General Tab
  • 6.2.2 Cached Queries: Execute Query Tab
  • 6.3 Viewing Code for Cached Queries
  • 6.4 Purging Cached Queries
  • 6.4.1 Purging All Cached Queries
  • 6.4.2 Purging Unused Cached Queries
  • 6.4.3 Purging Selected Queries
  • Chapter 7: 
     
  • 7.1 View Role Properties
  • 7.2 Add a New Role
  • 7.3 Edit a Role
  • 7.4 Delete a Role
  • 7.5 Grant User Access to a Role
  • 7.6 Assign Privileges to Roles
  • 7.7 Assign Object Privileges to Roles
  • Chapter 8: 
     
  • 8.1 User Properties
  • 8.2 Adding a User
  • 8.3 Editing a User
  • 8.4 Changing a User Description
  • 8.5 Changing a User Password
  • 8.6 Deleting a User
  • 8.7 Granting Privileges to Users
  • 8.8 Granting Role Access to a User
  • 8.9 Granting Object Privileges to a User