Contents Index Introduction to Interactive SQL dialog boxes Lookup Table Name dialog

SQL Anywhere Studio Help
  Interactive SQL Help

Lookup Procedure Name dialog


The Lookup Procedure Name dialog allows you to look up the names of procedures stored in the database. Once you find the procedure you are looking for, you can insert it into the SQL Statements pane at your current cursor position.

The Lookup Procedure Name dialog has the following components:

Tip  
You can use the SQL wildcard characters '%' (percent sign) and '_' (underscore) to help narrow your search. '%' matches any string of zero or more characters, while '_' matches any one character.

For example, to list all the procedures that contain the word profile, type %profile%.

If you want to search for a percent sign or underscore within a procedure name, you must prefix the percent sign or underscore with an escape character. The escape character depends on the JDBC driver that you are using. If you are connected via jConnect, the escape character is '\' (backslash) while the escape character for the iAnywhere JDBC driver is '~' (tilde).


Contents Index Introduction to Interactive SQL dialog boxes Lookup Table Name dialog