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

Text File | 1996-06-15 | 12KB | 229 lines

;SQL Central for SQL Anywhere - 5.0.03 - help contents file
:Base scsa.hlp>howto
:Index scfb=scfb.hlp                ;dummy entry to avoid Winhelp Find bug
:Link dbeng50w.hlp                  ;link to SQL Anywhere main help file
:Title SQL Central for SQL Anywhere

1 Introduction to SQL Central
2   What is SQL Central?=IDH_sc_intro
2   Requirements=IDH_scsa_requirements
2   Starting SQL Central=IDH_scsa_SQL_Central_start
2   How to get help=IDH_scsa_help
2   Contacting Sybase Customer Support=IDH_sc_customer_support

1 Connecting to a Database
2   Overview=IDH_scsa_database_connect
2   Connecting Manually
3     Using the connection dialog=IDH_scsa_database_connect_dialog
3     Connecting to a lone database on a lone local server=IDH_scsa_database_connect_lone
3     Connecting to a running database on a visible server=IDH_scsa_database_connect_visible_server
3     Connecting to a running database if you can't see the server=IDH_scsa_database_connect_invisible_server
3     Connecting to a database not currently running=IDH_scsa_database_connect_not_running
2   Using Connection Profiles
3     Overview=IDH_sc_profile_overview
3     Creating a new profile=IDH_sc_profile_create
3     Connecting using a profile=IDH_sc_profile_connect
3     Editing a profile=IDH_sc_profile_edit
3     Setting profiles to connect at startup=IDH_sc_profile_startup
3     Deleting profiles=IDH_sc_profile_delete

1 Using the Main Window
2   Layout of the main window=IDH_sc_main_window_layout
2   Changing the right-panel view=IDH_sc_panel_right_view
2   Navigating in panels=IDH_sc_panel_navigate
2   Selecting objects in panels=IDH_sc_panel_select
2   Refreshing the window=IDH_sc_main_window_refresh
2   Using the main toolbar=IDH_sc_main_window_toolbar
2   Using the status bar=IDH_sc_main_window_status_bar
2   Ending your SQL Central session=IDH_sc_SQL_Central_exit

1 Managing Servers
2   Showing all databases on a server=IDH_scsa_database_show
2   Starting a database without connecting=IDH_scsa_database_start
2   Stopping disconnected databases=IDH_scsa_database_stop
2   Inspecting Statistics for a Server
3     Showing statistics=IDH_scsa_server_statistic_show
3     Editing properties of a statistic=IDH_scsa_server_statistic_properties
3     Graphing with the SQL Central Performance Monitor
4       Overview=IDH_scsa_server_monitor_overview
4       Using the performance monitor=IDH_scsa_server_monitor_using
4       Adding statistics to the monitor=IDH_scsa_server_monitor_stats_add
4       Changing the type of monitor graph=IDH_scsa_server_monitor_graph_type
4       Editing display properties of a statistic=IDH_scsa_server_monitor_display_properties
4       Removing statistics from the monitor=IDH_scsa_server_monitor_stats_remove
4       Using the monitor toolbar=IDH_scsa_server_monitor_toolbar
4       Setting preferences=IDH_scsa_server_monitor_options
2     Graphing with the Windows NT performance monitor=IDH_scsa_server_monitor_NT

1 Managing Databases
2   Showing all databases on a server=IDH_scsa_database_show
2   Creating a new database=IDH_scsa_database_create
2   Editing properties of a database =IDH_scsa_database_properties
2   Showing system objects in a database=IDH_scsa_database_system_objects
2   Connecting to a database in ISQL=IDH_scsa_database_ISQL
2   Validating a database=IDH_scsa_database_validate
2   Extracting from a consolidated database=IDH_scsa_database_extract
2   Using passthrough mode with remote databases=IDH_scsa_database_passthrough
2   Disconnecting yourself from databases=IDH_scsa_database_disconnect
2   Stopping disconnected databases=IDH_scsa_database_stop
2   Using the SQL Anywhere Utilities
3     Creating a new database=IDH_scsa_database_create
3     Upgrading a database=IDH_scsa_database_upgrade
3     Backing up a database=IDH_scsa_database_backup
3     Compressing a database=IDH_scsa_database_compress
3     Uncompressing a database=IDH_scsa_database_uncompress
3     Creating a write file=IDH_scsa_database_write_file_create
3     Translating a log file=IDH_scsa_database_log_file_translate
3     Changing a log file=IDH_scsa_database_log_file_change
3     Unloading a database=IDH_scsa_database_unload
3     Extracting a remote database=IDH_scsa_database_extract
3     Erasing a database=IDH_scsa_database_erase

1 Managing Tables
2   Showing tables in a database=IDH_scsa_table_show
2   Creating a new table=IDH_scsa_table_create
2   Copying tables within/between databases=IDH_scsa_table_copy
2   Editing properties of a table=IDH_scsa_table_properties
2   Managing Columns
3     Showing columns=IDH_scsa_table_column_show
3     Creating a new column=IDH_scsa_table_column_create
3     Copying columns within/between tables=IDH_scsa_table_column_copy
3     Editing properties of a column=IDH_scsa_table_column_properties
3     Granting/revoking permissions on columns=IDH_scsa_table_column_permissions
3     Deleting columns=IDH_scsa_table_column_delete
2   Managing Table Constraints
3     Managing unique constraints=IDH_scsa_table_unique_constraint
3     Managing check constraints=IDH_scsa_table_check_constraint
2   Managing the Primary Key
3     Showing the primary key=IDH_scsa_primary_key_show
3     Editing the primary key=IDH_scsa_primary_key_edit
2   Managing Foreign Keys
3     Showing foreign keys=IDH_scsa_foreign_key_show
3     Creating a new foreign key=IDH_scsa_foreign_key_create
3     Editing properties of a foreign key=IDH_scsa_foreign_key_properties
3     Deleting foreign keys=IDH_scsa_foreign_key_delete
1   Showing references from other tables=IDH_scsa_reference_show
2   Managing Indexes
3     Showing indexes=IDH_scsa_index_show
3     Creating a new index=IDH_scsa_index_create
3     Editing properties of an index=IDH_scsa_index_properties
3     Validating indexes=IDH_scsa_table_validate
3     Deleting indexes=IDH_scsa_index_delete
2   Managing Triggers
3     Showing triggers=IDH_scsa_trigger_show
3     Creating a new trigger=IDH_scsa_trigger_create
3     Editing the code of a trigger=IDH_scsa_trigger_code
3     Editing properties of a trigger=IDH_scsa_trigger_properties
3     Deleting triggers=IDH_scsa_trigger_delete
1   Granting/revoking permissions=IDH_scsa_table_permissions
2   Validating tables=IDH_scsa_table_validate
2   Browsing a table's data in ISQL=IDH_scsa_table_ISQL
2   Deleting tables=IDH_scsa_table_delete

1 Managing Views
2   Showing views in a database=IDH_scsa_view_show
2   Creating a new view=IDH_scsa_view_create
2   Copying views within/between databases=IDH_scsa_view_copy
2   Editing the code of a view=IDH_scsa_view_code
2   Editing properties of a view=IDH_scsa_view_properties
2   Granting/revoking permissions=IDH_scsa_view_permissions
1   Browsing a view's data in ISQL=IDH_scsa_view_ISQL
1   Deleting views=IDH_scsa_view_delete

1 Managing Stored Procedures & Functions
2   Showing procedures in a database=IDH_scsa_procedure_show
2   Creating a new procedure=IDH_scsa_procedure_create
2   Copying procedures within/between databases=IDH_scsa_procedure_copy
2   Editing the code of a procedure=IDH_scsa_procedure_code
2   Editing properties of a procedure=IDH_scsa_procedure_properties
2   Granting/revoking permissions=IDH_scsa_procedure_permissions
2   Testing a procedure in ISQL=IDH_scsa_procedure_test
2   Deleting procedures=IDH_scsa_procedure_delete

1 Managing Users & Groups
2   Showing users and groups in a database=IDH_scsa_user_group_show
2   Creating a new user or group=IDH_scsa_user_group_create
2   Editing properties of a user or group=IDH_scsa_user_group_properties
2   Joining groups=IDH_scsa_user_group_join
2   Leaving groups=IDH_scsa_user_group_leave
2   Granting/revoking object permissions=IDH_scsa_user_group_permissions
2   Setting remote permissions for users
3     Granting remote permissions to users=IDH_scsa_remote_user_grant
3     Revoking remote permissions from users=IDH_scsa_remote_user_revoke
1   Deleting users and groups=IDH_scsa_user_group_delete

1 Managing User-defined Data Types
2   Showing user-defined types in a database=IDH_scsa_uddt_show
2   Creating a new user-defined type=IDH_scsa_uddt_create
2   Inspecting properties of a user-defined type=IDH_scsa_uddt_properties
2   Assigning user-defined types to columns=IDH_scsa_table_column_properties
2   Deleting user-defined types=IDH_scsa_uddt_delete

1 Managing SQL Remote Replication
2   Overview=IDH_scsa_SQL_Remote_overview
2   Managing Publications
3     Showing publications in a database=IDH_scsa_publication_show
3     Creating a new publication=IDH_scsa_publication_create
3     Editing properties of a publication=IDH_scsa_publication_properties
3     Managing Articles in a Publication
4       Showing articles=IDH_scsa_article_show
4       Creating a new article=IDH_scsa_article_create
4       Editing properties of an article=IDH_scsa_article_properties
4       Editing properties of an article's table=IDH_scsa_article_table_properties
4       Deleting articles=IDH_scsa_article_delete
2     Managing subscriptions for a publication=IDH_scsa_publication_subscription
2     Using passthrough mode for publications=IDH_scsa_SQL_Remote_passthrough
2     Deleting publications=IDH_scsa_publication_delete
2   Managing Users of SQL Remote
3     Showing users of SQL Remote in a database=IDH_scsa_remote_user_show
3     Creating a new remote user=IDH_scsa_remote_user_create
3     Editing properties of a remote user=IDH_scsa_remote_user_properties
3     Setting remote permissions
4       Granting remote permissions to users=IDH_scsa_remote_user_grant
4       Revoking remote permissions from users=IDH_scsa_remote_user_revoke
2     Managing subscriptions for a remote user=IDH_scsa_remote_user_subscription
3     Setting the publisher of a database=IDH_scsa_publisher_set
3     Extracting a database for a remote user=IDH_scsa_remote_user_extract
2     Using passthrough mode for remote users=IDH_scsa_SQL_Remote_passthrough
3     Deleting users of SQL Remote=IDH_scsa_remote_user_delete
2   Managing Message Types
3     Showing message types in a database=IDH_scsa_message_type_show
3     Creating a new message type=IDH_scsa_message_type_create
3     Editing properties of a message type=IDH_scsa_message_type_properties
3     Assigning message types to remote users=IDH_scsa_remote_user_properties
3     Deleting message types=IDH_scsa_message_type_delete
1   Starting replication (extracting remote databases)=IDH_scsa_SQL_Remote_extract
1   Deploying remote databases=IDH_scsa_SQL_Remote_deploy
1   Using passthrough mode with remote databases=IDH_scsa_SQL_Remote_passthrough

1 Managing Database Spaces
2   Showing spaces in a database=IDH_scsa_dbspace_show
2   Creating a new space=IDH_scsa_dbspace_create
2   Editing properties of a space=IDH_scsa_dbspace_properties
2   Deleting spaces=IDH_scsa_dbspace_delete

1 Managing Connected Users
2   Showing users connected to a database=IDH_scsa_connected_user_show
2   Inspecting properties of a connected user=IDH_scsa_connected_user_properties
2   Disconnecting a connected user=IDH_scsa_connected_user_disconnect

1 Other Topics
2   Drag-and-drop summary=IDH_scsa_drag_and_drop
2   Using ISQL with SQL Central
3     Connecting to a database in ISQL=IDH_scsa_database_ISQL
3     Browsing a table's data in ISQL=IDH_scsa_table_ISQL
3     Browsing a view's data in ISQL=IDH_scsa_view_ISQL
3     Testing a stored procedure in ISQL=IDH_scsa_procedure_test
2   Using SQL Central's Code Editor
3     Overview=IDH_sc_code_editor_overview
3     Setting the display font=IDH_sc_code_editor_font
3     Finding text=IDH_sc_code_editor_find
3     Replacing text=IDH_sc_code_editor_replace
3     Jumping to a line number=IDH_sc_code_editor_goto_line
3     Opening an external file=IDH_sc_code_editor_open_file
3     Saving code as an external file=IDH_sc_code_editor_save_file
3     Executing code as DDL=IDH_sc_code_editor_execute
3     Using the toolbar=IDH_sc_code_editor_toolbar
3     Using the status bar=IDH_sc_code_editor_status_bar