/SQL/Search In the Data using ObjectName

Search In the Data using ObjectName

declare @ObjectName nvarchar(max)='objectName'
SELECT  o.[name] as object_name
                                                            , sm.[definition]
                                                    FROM sys.sql_modules AS sm
                                                    JOIN sys.objects AS o
                                                        ON sm.object_id = o.object_id
                                                    JOIN sys.schemas AS ss
                                                        ON o.schema_id = ss.schema_id
where o.name=@ObjectName

Source: rapidtables.com

Similar codes

0 vote105 views1 answer
Sql query contains multiple ids
SQL
0 vote140 views5 answers
How to make trigger in phpmyadmin
SQL
1 vote136 views1 answer
How not to sort by average rating
SQL
8 votes129 views1 answer
Alter tablespace add datafile autoextend
SQL
4 votes99 views1 answer
Oracle show error line number
SQL
0 vote158 views1 answer
Site:av.ru "files"
SQL
0 vote114 views1 answer
Oracle flush Shared Pool
SQL
-1 vote100 views1 answer
Convert google analytics dathourminute to time stamp? sql
SQL
0 vote114 views1 answer
Mysql 5.6 hierarchical recursive query
SQL
0 vote96 views1 answer
How to print out column name differently in mysql
SQL