PC World 1997 November/PCWorld_1997-11_cd.bin/software/programy/komix/DATA.Z/sc.cnt

Microsoft Windows Help File Content | 1996-04-01 | 11.8 KB | 207 lines

;SQL Central 5.0.02 help contents file
:Base sc.hlp>howto
:Title SQL Central
:Link dbeng50w.hlp            ; link to SQL Anywhere main help file
1 Introduction to SQL Central
2   What is SQL Central?=IDH_DBX_SQL_Central_intro
2   Requirements=IDH_DBX_Requirements
2   Starting SQL Central=IDH_DBX_Starting_SQL_Central
2   How to get help=IDH_DBX_help
2   Contacting Sybase Customer Support=IDH_DBX_customer_support
1 Connecting to a Database
2   Overview=IDH_DBX_connecting_to_a_database
2   Connecting Manually
3     Using the connection dialog=IDH_DBX_opening_the_connection_dialog
3     Connecting to a lone database on a lone local server=IDH_DBX_connecting_to_lone_database
3     Connecting to a running database on a visible server=IDH_DBX_connecting_to_database_visible_server
3     Connecting to a running database if you can't see the server=IDH_DBX_connecting_to_database_invisible_server
3     Connecting to a database not currently running=IDH_DBX_connecting_to_database_not_running
2   Using Connection Profiles
3     Overview=IDH_DBX_profile_overview
3     Creating a new profile=IDH_DBX_Creating_a_new_profile
3     Connecting using a profile=IDH_DBX_Connecting_with_profile
3     Editing a profile=IDH_DBX_Editing_a_profile
3     Setting profiles to connect at startup=IDH_DBX_Connecting_profiles_on_startup
3     Deleting profiles=IDH_DBX_Deleting_profiles
1 Using the Main Window
2   Layout of the main window=IDH_DBX_main_window
2   Navigating in panels=IDH_DBX_Navigating_in_panels
2   Selecting objects in panels=IDH_DBX_Selecting_in_panels
2   Changing the right-panel view=IDH_DBX_Changing_the_right_panel_view
2   Refreshing the window=IDH_DBX_Refreshing_the_Window
2   Using the main toolbar=IDH_DBX_Using_the_main_toolbar
2   Using the status bar=IDH_DBX_Using_main_status_bar
2   Exiting from SQL Central=IDH_DBX_Exiting_from_SQL_Central
1 Managing Servers
2   Showing all databases on a server=IDH_DBX_Showing_databases
2   Starting a database without connecting=IDH_DBX_database_start
2   Stopping databases=IDH_DBX_database_stop
2   Inspecting Statistics for a Server
3     Showing statistics=IDH_DBX_server_statistics_show
3     Inspecting a statistic's properties=IDH_DBX_Inspecting_a_statistic
3     Graphing with the SQL Central Performance Monitor
4       Overview=IDH_DBX_monitor_overview
4       Using the performance monitor=IDH_DBX_monitor_using
4       Adding and removing statistics=IDH_DBX_monitor_adding_and_removing_statistics
4       Editing a statistic's display properties=IDH_DBX_monitor_editing_display_properties
4       Using the monitor toolbar=IDH_DBX_Using_the_monitor_toolbar
4       Setting preferences=IDH_DBX_monitor_setting_preferences
2     Graphing with the Windows NT performance monitor=IDH_DBX_server_statistics_NT
1 Managing Databases
2   Showing all databases on a server=IDH_DBX_Showing_databases
2   Editing a database's properties=IDH_DBX_Editing_database_properties
2   Showing system objects in a database=IDH_DBX_database_system_objects
2   Connecting to a database in ISQL=IDH_DBX_database_ISQL
2   Validating a database=IDH_DBX_Validating_a_database
2   Extracting from a consolidated database=IDH_DBX_database_extract
2   Using passthrough mode with remote databases=IDH_DBX_SQL_Remote_passthrough
2   Disconnecting yourself from databases=IDH_DBX_Disconnecting_from_databases
2   Stopping databases=IDH_DBX_database_stop
2   Using the Database Utilities
3     Creating a new database=IDH_DBX_Creating_a_new_database
3     Upgrading a database=IDH_DBX_Upgrading_a_database
3     Validating a database=IDH_DBX_Validating_a_database
3     Backing up a database=IDH_DBX_Backing_up_a_database
3     Compressing a database=IDH_DBX_Compressing_a_database
3     Uncompressing a database=IDH_DBX_Uncompressing_a_database
3     Creating a write file=IDH_DBX_creating_a_write_file
3     Translating a log file=IDH_DBX_Translating_a_log_file
3     Changing a log file=IDH_DBX_Changing_a_log_file
3     Unloading a database=IDH_DBX_Unloading_a_database
3     Extracting a remote database=IDH_DBX_SQL_Remote_extract
3     Erasing a database=IDH_DBX_Erasing_a_database
1 Managing Tables
2   Showing tables in a database=IDH_DBX_Showing_tables
2   Creating a new table=IDH_DBX_Creating_a_new_table
2   Editing a Table's Properties
3     Opening the table's property sheet=IDH_DBX_Editing_a_table
3     Managing the Primary Key
4       Showing the primary key=IDH_DBX_Showing_the_primary_key
4       Editing the primary key=IDH_DBX_Editing_the_primary_key
3     Managing Table Constraints
4       Managing unique constraints=IDH_DBX_table_unique_constraint
4       Managing check constraints=IDH_DBX_table_check_constraint
2     Granting/revoking permissions=IDH_DBX_editing_table_permissions
2   Managing Columns
3     Showing columns=IDH_DBX_Showing_columns
3     Creating a new column=IDH_DBX_Creating_a_new_column
3     Editing a column's properties=IDH_DBX_Editing_column_properties
3     Granting/revoking permissions on columns=IDH_DBX_editing_table_column_permissions
3     Deleting columns=IDH_DBX_Deleting_columns
2   Managing the Primary Key
3     Showing the primary key=IDH_DBX_Showing_the_primary_key
3     Editing the primary key=IDH_DBX_Editing_the_primary_key
2   Managing Foreign Keys
3     Showing foreign keys=IDH_DBX_Showing_foreign_keys
3     Creating a new foreign key=IDH_DBX_Creating_a_new_foreign_key
3     Editing a foreign key's properties=IDH_DBX_Editing_a_foreign_key
3     Deleting foreign keys=IDH_DBX_Deleting_foreign_keys
1   Showing references from other tables=IDH_DBX_Showing_references
2   Managing Indexes
3     Showing indexes=IDH_DBX_Showing_indexes
3     Creating a new index=IDH_DBX_Creating_a_new_index
3     Editing an index's properties=IDH_DBX_Editing_an_index
3     Validating indexes=IDH_DBX_Validating_tables
3     Deleting indexes=IDH_DBX_Deleting_indexes
2   Managing Triggers
3     Showing triggers=IDH_DBX_Showing_triggers
3     Creating a new trigger=IDH_DBX_Creating_a_new_trigger
3     Inspecting a trigger's code=IDH_DBX_Editing_trigger_code
3     Editing a trigger's properties=IDH_DBX_Editing_trigger_properties
3     Deleting triggers=IDH_DBX_Deleting_triggers
2   Managing Table Constraints
3     Managing unique constraints=IDH_DBX_table_unique_constraint
3     Managing check constraints=IDH_DBX_table_check_constraint
1   Granting/revoking permissions=IDH_DBX_editing_table_permissions
2   Validating tables=IDH_DBX_Validating_tables
2   Browsing a table's data in ISQL=IDH_DBX_table_ISQL
2   Deleting tables=IDH_DBX_Deleting_tables
1 Managing Views
2   Showing views in a database=IDH_DBX_Showing_views
2   Creating a new view=IDH_DBX_Creating_a_new_view
2   Inspecting a view's code=IDH_DBX_Editing_view_code
2   Editing a View's Properties
3     Opening the view's property sheet=IDH_DBX_editing_view_properties
3     Granting/revoking permissions=IDH_DBX_editing_view_permissions
1   Browsing a view's data in ISQL=IDH_DBX_view_ISQL
1   Deleting views=IDH_DBX_Deleting_views
1 Managing Stored Procedures & Functions
2   Showing procedures in a database=IDH_DBX_Showing_procedures
2   Creating a new procedure=IDH_DBX_Creating_a_new_procedure
2   Editing a procedure's code=IDH_DBX_Editing_procedure_code
2   Editing a Procedure's Properties
3     Opening the procedure's property sheet=IDH_DBX_editing_procedure_properties
3     Granting/revoking permissions=IDH_DBX_editing_procedure_permissions
1   Testing a procedure in ISQL=IDH_DBX_procedure_test
1   Deleting procedures=IDH_DBX_Deleting_procedures
1 Managing Users & Groups
2   Showing users and groups in a database=IDH_DBX_Showing_users_and_groups
2   Creating a new user or group=IDH_DBX_Creating_a_new_user_or_group
2   Editing Properties of a User or Group
3     Opening the user/group's property sheet=IDH_DBX_editing_users_groups
3     Joining groups=IDH_DBX_user_group_joining
3     Leaving groups=IDH_DBX_user_group_leaving
3     Granting/revoking object permissions=IDH_DBX_editing_user_permissions
2   Managing remote permissions for users
3     Granting remote permissions to users=IDH_DBX_SQL_Remote_user_permissions_grant
3     Revoking remote permissions from users=IDH_DBX_SQL_Remote_user_permissions_revoke
1   Deleting users and groups=IDH_DBX_Deleting_users_and_groups
1 Managing User-defined Data Types
2   Showing user-defined types in a database=IDH_DBX_uddt_show
2   Creating a new user-defined types=IDH_DBX_uddt_create
2   Assigning user-defined types to columns=IDH_DBX_column_data_type
2   Deleting user-defined types=IDH_DBX_uddt_delete
1 Managing SQL Remote Replication
2   Managing Publications
3     Showing publications in a database=IDH_DBX_SQL_Remote_showing_pubs
3     Creating a new publication=IDH_DBX_SQL_Remote_creating_pubs
3     Editing a publication's properties=IDH_DBX_SQL_Remote_pub_properties
3     Managing Articles in a Publication
4       Showing articles=IDH_DBX_SQL_Remote_showing_articles
4       Creating a new article=IDH_DBX_SQL_Remote_creating_articles
4       Editing an article's properties=IDH_DBX_SQL_Remote_article_properties
4       Deleting articles=IDH_DBX_SQL_Remote_deleting_articles
2     Managing subscriptions for a publication=IDH_DBX_SQL_Remote_pub_subscription
2     Using passthrough mode for publications=IDH_DBX_SQL_Remote_passthrough
2     Deleting publications=IDH_DBX_SQL_Remote_deleting_pubs
2   Managing Users of SQL Remote
3     Showing users of SQL Remote in a database=IDH_DBX_SQL_Remote_showing_users
3     Creating a new remote user=IDH_DBX_SQL_Remote_creating_user
3     Editing properties of a remote user=IDH_DBX_SQL_Remote_user_properties
3     Managing remote permissions
4       Granting remote permissions to users=IDH_DBX_SQL_Remote_user_permissions_grant
4       Revoking remote permissions from users=IDH_DBX_SQL_Remote_user_permissions_revoke
2     Managing subscriptions for a remote user=IDH_DBX_SQL_Remote_user_subscription
3     Setting the publisher of a database=IDH_DBX_SQL_Remote_publisher
3     Extracting a database for a remote user=IDH_DBX_SQL_Remote_user_extract
2     Using passthrough mode for remote users=IDH_DBX_SQL_Remote_passthrough
3     Deleting users of SQL Remote=IDH_DBX_SQL_Remote_deleting_users
2   Managing Message Types
3     Showing message types in a database=IDH_DBX_SQL_Remote_message_type_show
3     Creating a new message type=IDH_DBX_SQL_Remote_message_type_create
3     Editing properties of a message type=IDH_DBX_SQL_Remote_message_type_properties
3     Assigning message types to remote users=IDH_DBX_SQL_Remote_user_properties
3     Deleting message types=IDH_DBX_SQL_Remote_message_type_delete
1   Starting replication (extracting remote databases)=IDH_DBX_SQL_Remote_extract
1   Using passthrough mode with remote databases=IDH_DBX_SQL_Remote_passthrough
1 Managing Database Spaces
2   Showing spaces in a database=IDH_DBX_Showing_dbspaces
2   Creating a new space=IDH_DBX_Creating_a_new_dbspace
2   Editing a space's properties=IDH_DBX_Editing_dbspace
2   Deleting spaces=IDH_DBX_Deleting_dbspaces
1 Managing Connected Users
2   Showing users connected to a database=IDH_DBX_connected_user_show
2   Inspecting a connected user's properties=IDH_DBX_connected_user_properties
2   Disconnecting a connected user=IDH_DBX_connected_user_disconnect
1 Using ISQL with SQL Central
2   Connecting to a database in ISQL=IDH_DBX_database_ISQL
2   Browsing a table's data in ISQL=IDH_DBX_table_ISQL
2   Browsing a view's data in ISQL=IDH_DBX_view_ISQL
2   Testing a stored procedure in ISQL=IDH_DBX_procedure_test
1 Other Topics
2   SQL Central's Code Editor
3     Using the code editor=IDH_DBX_using_code_editor
3     Using the toolbar=IDH_DBX_using_the_editor_toolbar
3     Using the status bar=IDH_DBX_Using_editor_status_bar
1   Summary of drag-and-drop operations=IDH_DBX_Drag_and_drop