SQL Studio: SAP DB 7.4
Starting SQL Studio
Opening a Database Session
Options for Connecting to the Database
Recent Sessions List
Logging Off from the Database
User Settings
Catalog Manager
SQL Studio Objects
Tables
Creating a Database Table
Defining Columns
Defining Constraints
Defining Foreign Key Dependencies
Defining Miscellaneous Information
Creating a View Table
Creating a Synonym
Displaying the Definition of a Table
Changing the Definition of a Database Table
Displaying the Contents of a Table
Renaming a Table
Deleting all Rows of a Table
Deleting a Table
Indexes
Creating an Index
Displaying the Definition of an Index
Deleting an Index
Number Sequences
Creating a Sequence
Displaying the Definition of a Sequence
Deleting a Sequence
Favorites
User
Database Procedures
SQL Dialog
Creating SQL Statements
Keyword List
Setting Parameters for SQL Statements
Importing and Exporting SQL Statements
Executing SQL Statements
Form Dialog
Executing a Form Dialog
Selecting Data Records Using Search Conditions
Changing Data Records
Inserting Data Records
Deleting a Data Record
Importing and Exporting LONG Columns
Visual Query Dialog
Creating a Visual Query
Linking Table Columns with JOINS
Entering Search Conditions
Setting Parameters for Search Conditions
Defining the Result View
Executing a Visual Query
Result Tables
Adjusting the Result View
Saving a Result