Hi all...We have Sybase Central 4.3.0. Once I connect to my
DB there are folders for Tables, Views, Indexes, Triggers,
etc...
So far so good. My question is a simple one...Is there any
way to globally search the contents of all the Stored
Procedures or Views or Triggers in my DB using some sort of
search utility?

One way is to query the system catalog...

BEGIN
SELECT * FROM SYSTABLE WHERE view_def LIKE '%xxx%';
SELECT * FROM SYSPROCEDURE WHERE proc_defn LIKE '%xxx%';
SELECT * FROM SYSTRIGGER WHERE trigger_defn LIKE '%xxx%';
SELECT * FROM SYSEVENT WHERE source LIKE '%xxx%';
END;

AFAIK there is no way to do global edits (your next question?

Breck

On 31 Oct 2007 11:14:20 -0700, Mark wrote:

--
Breck Carter [Team iAnywhere]
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com
The book: http://www.risingroad.com/SQL_Anywhe...ers_Guide.html
breck.carter (AT) risingroad (DOT) com

Another way to search the schema is to unload it to a file, then search the
resulting file. For example, "dbunload -n -c uid=xxx;pwd=yyy" will create
reload.sql. Sybase Central provides an equivalent "schema-only" unload.

Whitepapers, TechDocs, bug fixes at http://www.ianywhere.com/developer

<Mark> wrote

Two options come to mind:

1. Reverse engineer into PowerDesigner and use one of a number of
techniques there.
2. Upgrade to latest SQL Anywhere. Sybase Central 5 provides a search
feature that does exactly what you are after.

<Mark> wrote