;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