Using Caché SQL Manager
Static Version
Contents
Contents
Chapter 1:
Introduction
1.1 Overview
1.2 Starting SQL Manager
1.3 Organization of this Document
Chapter 2:
SQL Manager Commands
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:
General Tasks
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:
Tables
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:
Views
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:
Queries
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:
Roles and Privileges
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:
Users
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
Copyright
© 1997-2003, InterSystems Corp.
Last updated:
2001-11-21 13:48:47
Source:
GSQM.xml