Alex A
asked on
SQL Server: searching database VIEW scripts
Hi, we'd like to query all database views for certain keywords, for example certain table/column names or business related words.
Thank you in advance.
Thank you in advance.
If you need to just search for keywords, and not specifically column names, you may try something like this:
HTH.
WITH myviews(object_schema, object_name, object_type, definition)
AS
(
SELECT SCHEMA_NAME(o.schema_id) AS object_schema
,OBJECT_NAME(o.object_id) AS object_name
,o.type_desc AS object_type
,OBJECT_DEFINITION(o.object_id)
FROM sys.objects AS o
where o.type = 'V'
--ORDER BY object_schema, object_name;
)
SELECT * FROM myviews WHERE definition like '%keyword%'
HTH.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Open in new window