Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

How do I do a keyword search on DB objects

2 posts in Windows NT Last posting was on 2000-06-29 14:10:14.0Z
madhu Bharadwaj Posted on 2000-06-28 21:42:11.0Z
Message-ID: <395A7133.33B54071@mmm.com>
Date: Wed, 28 Jun 2000 16:42:11 -0500
From: madhu Bharadwaj <msbharadwaj@mmm.com>
X-Mailer: Mozilla 4.5 [en]C-CCK-MCD 3M/NCP 4.5 (WinNT; I)
X-Accept-Language: en
MIME-Version: 1.0
Subject: How do I do a keyword search on DB objects
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 10
NNTP-Posting-Host: 169.10.116.232
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:1960
Article PK: 1089402

I am looking for a utility/tool which allows a keyword search on the DDL
for all the objects in a database.
Eg. I want to make a list of all objects which use the word 'case'

I generally use SSM or Sybase SQL Anywhere and I don't see any way of
doing it in these. I want to avoid writing queries which access the
system tables.

thanks,
madhu


Swami Posted on 2000-06-29 14:10:14.0Z
Message-ID: <395B58C6.6BFF68B4@guru.com>
Date: Thu, 29 Jun 2000 17:10:14 +0300
From: Swami <swami@guru.com>
X-Mailer: Mozilla 4.7 [en] (WinNT; I)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: How do I do a keyword search on DB objects
References: <395A7133.33B54071@mmm.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 16
NNTP-Posting-Host: pool-86.suntel-lems.ro 194.102.106.86
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:1958
Article PK: 1089370

Not able to get your question fully. Anyway, if you are looking for object
name's with the word case, then you may try this one

select name from sysobjects where name like '%case%'

hope this help

good luck

madhu Bharadwaj wrote:

> I am looking for a utility/tool which allows a keyword search on the DDL
> for all the objects in a database.
> Eg. I want to make a list of all objects which use the word 'case'
>
> I generally use SSM or Sybase SQL Anywhere and I don't see any way of
> doing it in these. I want to avoid writing queries which access the
> system tables.
>
> thanks,
> madhu