How to Search a Text into a Database objects
-
Hi I have to search a string into a database object. the string can be a part of SP or Function or any other sys object. Thanks in Advance
-
Hi I have to search a string into a database object. the string can be a part of SP or Function or any other sys object. Thanks in Advance
SELECT DISTINCT so.name
FROM syscomments sc
INNER JOIN sysobjects so ON sc.id=so.id
WHERE sc.TEXT LIKE '%Employee%'Vaibhav
-
SELECT DISTINCT so.name
FROM syscomments sc
INNER JOIN sysobjects so ON sc.id=so.id
WHERE sc.TEXT LIKE '%Employee%'Vaibhav
Thanks Vaibhav... Will it work for SQL 2005
-
Thanks Vaibhav... Will it work for SQL 2005
I am not sure :) Please check.
Vaibhav
-
Hi I have to search a string into a database object. the string can be a part of SP or Function or any other sys object. Thanks in Advance
Hi I found.. SELECT * FROM all_source WHERE Lower(text) LIKE '%reportid%' this will work for Oracle
-
Hi I have to search a string into a database object. the string can be a part of SP or Function or any other sys object. Thanks in Advance
If you have to do this sort of thing regularly, you might want to look at SQL Search[^]. It's free at the moment, although they might decide to charge for future versions.
"These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer
