:Base scsa.hlp>howto :Title Sybase Central for SQL Anywhere :Index scfb =scfb.hlp :Link dbeng50w.hlp 1 Introduction to Sybase Central 2 What is Sybase Central?=IDH_sc_intro 2 Plug-in architecture=IDH_sc_plugin_intro 2 Requirements for SQL Anywhere=IDH_scsa_requirements 1 Starting Sybase Central=IDH_scsa_SQL_Central_start 1 How to get help=IDH_scsa_help 1 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 2 Using the Main Window 3 Layout of the main window=IDH_sc_main_window_layout 3 Changing the right-panel view=IDH_sc_panel_right_view 3 Navigating in panels=IDH_sc_panel_navigate 3 Selecting objects in panels=IDH_sc_panel_select 3 Refreshing the window=IDH_sc_main_window_refresh 3 Using the main toolbar=IDH_sc_main_window_toolbar 3 Using the status bar=IDH_sc_main_window_status_bar 3 Ending your Sybase Central session=IDH_sc_SQL_Central_exit 2 Managing Servers 3 Showing all databases on a server=IDH_scsa_database_show 3 Starting a database without connecting=IDH_scsa_database_start 3 Stopping disconnected databases=IDH_scsa_database_stop 3 Inspecting Statistics for a Server 4 Showing statistics=IDH_scsa_server_statistic_show 4 Editing properties of a statistic=IDH_scsa_server_statistic_properties 4 Graphing with the Sybase Central Performance Monitor 5 Overview=IDH_scsa_server_monitor_overview 5 Using the performance monitor=IDH_scsa_server_monitor_using 5 Adding statistics to the monitor=IDH_scsa_server_monitor_stats_add 5 Changing the type of monitor graph=IDH_scsa_server_monitor_graph_type 5 Editing display properties of a statistic=IDH_scsa_server_monitor_display_properties 5 Removing statistics from the monitor=IDH_scsa_server_monitor_stats_remove 5 Using the monitor toolbar=IDH_scsa_server_monitor_toolbar 5 Setting preferences=IDH_scsa_server_monitor_options 3 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 Setting a consolidated database=IDH_To_set_a_consolidated_database 2 Setting options for a database=IDH_scsa_database_options 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 Service Manager 3 Managing the Service Manager=IDH_Managing_the_Service_Manager 3 Editing a service=IDH_To_Edit_a_Service 3 Starting and Stopping a Service=IDH_Starting_and_Stopping_a_Service 3 Adding a Service=IDH_Adding_a_Service 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 Rebuilding a Database=IDH_Rebuilding_a_Database 3 Extracting a remote database=IDH_scsa_database_extract 3 Validating a database=IDH_scsa_database_validate 3 Erasing a database=IDH_scsa_database_erase 3 Starting ISQL=IDH_scsa_utilities_isql 3 Starting InfoMaker=IDH_scsa_utilities_infomaker 2 Managing Tables 3 Showing tables in a database=IDH_scsa_table_show 3 Creating a new table=IDH_scsa_table_create 3 Copying tables within/between databases=IDH_scsa_table_copy 3 Editing properties of a table=IDH_scsa_table_properties 3 Using the Table Editor 4 Overview=IDH_scsa_table_editor_overview 4 Setting the table's type=IDH_scsa_table_editor_table_type 4 Managing columns=IDH_scsa_table_editor_column 4 Editing the primary key=IDH_scsa_table_editor_primary_key 4 Using the toolbar=IDH_scsa_table_editor_toolbar 3 Managing Columns 4 Showing columns=IDH_scsa_table_column_show 4 Creating a new column=IDH_scsa_table_column_create 4 Copying columns within/between tables=IDH_scsa_table_column_copy 4 Editing columns in the table editor=IDH_scsa_table_column_editor 4 Editing properties of a column=IDH_scsa_table_column_properties 4 Setting permissions on columns=IDH_scsa_table_column_permissions 4 Deleting columns=IDH_scsa_table_column_delete 3 Managing Table Constraints 4 Managing unique constraints=IDH_scsa_table_unique_constraint 4 Managing check constraints=IDH_scsa_table_check_constraint 3 Managing the Primary Key 4 Showing the primary key=IDH_scsa_primary_key_show 4 Editing the primary key=IDH_scsa_primary_key_edit 3 Managing Foreign Keys 4 Showing foreign keys=IDH_scsa_foreign_key_show 4 Creating a new foreign key=IDH_scsa_foreign_key_create 4 Editing properties of a foreign key=IDH_scsa_foreign_key_properties 4 Deleting foreign keys=IDH_scsa_foreign_key_delete 2 Showing references from other tables=IDH_scsa_reference_show 1 Managing Indexes 2 Showing indexes=IDH_scsa_index_show 2 Creating a new index=IDH_scsa_index_create 2 Editing properties of an index=IDH_scsa_index_properties 2 Validating indexes=IDH_scsa_table_validate 2 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 Setting permissions=IDH_scsa_table_permissions 1 Validating tables=IDH_scsa_table_validate 1 Unloading tables=IDH_scsa_table_unload 1 Browsing a table's data in ISQL=IDH_scsa_table_ISQL 1 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 Setting 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 Procedures & Functions 2 Showing procedures & functions 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 Setting 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 Setting 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 Setting options for a user or group=IDH_scsa_user_group_options 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 2 Setting the publisher of a database=IDH_scsa_publisher_set 2 Extracting a database for a remote user=IDH_scsa_remote_user_extract 2 Using passthrough mode for remote users=IDH_scsa_SQL_Remote_passthrough 2 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 Plug-in Modules 3 Plug-in architecture=IDH_sc_plugin_intro 3 Managing plug-ins=IDH_sc_plugin_manage 2 Using ISQL with Sybase Central 3 Starting ISQL=IDH_scsa_utilities_isql 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 procedure in ISQL=IDH_scsa_procedure_test 2 Using Sybase 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 Printing code=IDH_sc_code_editor_print 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