Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - Database Administration » Database administration » SQL Anywhere graphical administration tools » Sybase Central

 

Searching for database objects

Within Sybase Central, you can search a database for a specified database object, or search for a string within the SQL of a database object.

Prerequisites

If you do not have the necessary privileges to view the Login Mappings folder, Maintenance Plans folder, or the Page Usage or Locks tab for a database, any search you perform skips these folders and/or tabs.

 Task

  1. In Sybase Central, use the SQL Anywhere 16 plug-in to connect to a database.

  2. Click View » Search Pane.

    The Search pane appears in the left pane.

  3. Configure options for the search.

    Option Action
    SQL Anywhere 16 plug-in

    • Search In SQL   Select this option to include the SQL of procedures, events, functions and triggers in the search.

    • Search Dynamic Properties (Connections, Statistics, Locks)   Select this option to include dynamic properties, such as connected users, SQL Remote statistics, table locks, and table page usage information in the search.

    MobiLink 16 plug-in

    • Search In Scripts   Select this option to include synchronization scripts in the search.

  4. Click Search.

Results

The search results appear in Results in the left pane. Double-click a result to open it in the right pane.

Sybase Central keyboard shortcuts

Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0