Search Criteria Page

The Search Criteria page of the DB Search panel allows you to define required search criteria.

It allows to define the following options:

Search For dropdown list -  it provides two options: 

• performs search for a database object reference, such as table or stored procedure. In this case the search engine considers only object identifiers and ignore all text constants, comments or SQL keywords within stored syntax. For example, if you search for a table account, the search engine will ignore all references to stored procedures called account or to all text constants, containing word account.
• performs text string search within stored database object syntax. In this case the search engine looks for any occurrence of the search string.

Search For Database Object Reference Parameters

Object Name - the name of the object or wildcard for name of group of objects you want to search. For wildcard use * character to specify any number of characters and ? character to specify any single character.

Object Type - allows to specify exactly the type of object you are looking for. For example, tables or stored procedures. The default value is 'ANY', which means to search for any object, which satisfies the object name filter.

Owned By - the optional filter by the object owner

Column - if the object type is table/view, it allows to specify the optional column name. For example, you can search for any references to column ID_Account of tbl_Account.

Tables in Context Of - this option is available if the object type is table/view. You can narrow down the search only to places where the table is used in a context of particular operation. For example, it allows you to find all places, where the table is updated using UPDATE/DELETE operations and ignore all places where it is being queried using SELECT operation.

Search In - it allows to specify the target search area. You can specify to search across one or multiple databases and also narrow down the list of objects, in which the search is performed. For example, you can search for all references to a table tbl_Account in all stored procedures, which name start with ACCT. Check External Routines allows to include in search syntax of stored procedures defined for external routines written in C using EXTERNAL keyword.

Search for a Text String Parameters

Text to Find - enter the text string, which you are looking for.

Whole Words Only - to search only for whole words, which match the string entered in TextTo Find field.

Case Sensitive - to perform case sensitive search.

Search In - it allows you to specify the target search area. You can specify to search across one or multiple databases and also narrow down the list of objects, in which the search is performed. For example, you can search for all occurrences of string my_variable in all stored procedures, which name start with ACCT.

Executing Search Operation

The search operation starts when you press Search button at the bottom of the panel. This operations is asyncronious so you can switch to other documents, such as SQL Editor, and continue working while the search is performed.

You can cancel the search operation by pressing Cancel button at the bottom of the page.