Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 12.0.1 » Context-Sensitive Help » Interactive SQL help

 

Lookup Procedure Name window

The Lookup Procedure Name window 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.

This window has the following components:

  • Type the first few characters of the procedure you are looking for   Type the first few characters of the procedure name in the text box to restrict the list of procedures to only those that start with the text you enter.

  • Click the procedure you want, then click OK   Select the procedure from the list. Click OK to insert the procedure name into the SQL Statements pane at your current cursor position.

  • Show owner names   Select this option if you want to prefix each procedure name in the list with the name of the database user who owns the procedure.

  • Show system objects   Select this option if you want the system-supplied stored procedures to appear in the list.

    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 a ~ (tilde).

 See also