Locate page
Object type
Column
Comparison
Values
Meet all conditions
Meet any conditions
Clear
OK
Apply
Cancel
Object type
Use this field to select the type of object to search for. All of the database objects in the object tree are available to search. The column fields on this Locate page adjust according to the object type selected.
If you select Locate from the Database folder, you have all objects available to you in the Object type field. In this case your search would only be limited by the database and the criteria you define on the Locate page. To contrast this broad search, if you originated your search by selecting Locate from the Indexes folder inside a Database object on the tree, your options for Object type are limited to Indexes only. You could only search for another index type in this case.
Column
Use this field to specify one catalog column for each of the five Column fields to be used in the search. The selected columns can even be the same with different values to search for. But, you are not limited to these five columns because of the additional changes you can make using the Advanced page of the Locate notebook.
Comparison
Use this field to specify an SQL operator to help define the query. Click on the arrow to display all the SQL operator choices. See SQL operators - in the SQL Reference for more information on the choices.
Values
Use this field to specify the value or values to use in the comparison. The search is case sensitive. Multiple values must be separated by a comma, with each set delimited with a set of single quotes. Multiple values are generally used in an IN or NOT IN statement. In a LIKE comparison, you can use the % wildcard character to match 0 or more characters; or, you can use the underscore (_) wildcard character to match exactly one character. For example:
Meet all conditions
Use this radio button to implicitly add an AND between the search criteria.
Meet any conditions
Use this radio button to add an OR between the search criteria.
Advanced page
Object type
Customize the where clause
Reset
OK
Apply
Cancel
Object type
Use this field to select the type of object to search for. All of the database objects in the object tree are available to search. The column fields on this Locate page adjust according to the object type selected.
If you select Locate from the Database folder, you have all objects available to you in the Object type field. In this case your search would only be limited by the database and the criteria you define on the Locate page. To contrast this broad search, if you originated your search by selecting Locate from the Indexes folder inside the Database object on the tree, your options for Object type are limited to Indexes only. You could only search for another index type in this case.
Customize the where clause
Use this field to derive your own WHERE clause, or add more predicate columns to the existing clause.
Reset
If this button is enabled, you have made changes to the WHERE clause that was generated from the Locate page of the Locate notebook, and the generated clause will not be used in the object search. The changes you make on the Advanced page become your new WHERE clause. Select the Reset button to revert back to the generated WHERE clause from the Locate page of the Locate notebook.