Search for a Text in Sybase and SQL Server Database

SQL Server Code:

select
S.name as [Schema],
o.name as [Object] ,
o.type_desc as [Object_Type],
C.text as [Object_Definition]
from sys.all_objects O inner join sys.schemas S on O.schema_id = S.schema_id
inner join sys.syscomments C on O.object_id = C.id
where S.schema_id not in (3,4) -- avoid searching in sys and INFORMATION_SCHEMA schemas
and C.text like '%%'
order by [Schema]


Sybase Code:

Select distinct sysobjects.name
, case
 when sysobjects.type = 'TR' then 'TRIGGER'
 when sysobjects.type = 'P' then 'PROCEDURE'
 when sysobjects.type = 'V' then 'VIEW'
 else 'UNKNOWN' end type
from sysobjects inner join syscomments
on sysobjects.id = syscomments.id
where syscomments.text like '%tbl_books%'


Et Voila
Pushparaj