/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 vote223 views1 answer
How to run mysql in git bash
SQL
1 vote277 views1 answer
Aqua Data studio postgresql ssl
SQL
1 vote235 views1 answer
UseSqlServer no definition
SQL
1 vote202 views2 answers
String to date postgres
SQL
0 vote236 views1 answer
Combine 2 columns search query mysql
SQL
3 votes199 views2 answers
Coalesce mysql
SQL
0 vote213 views1 answer
Character count sql
SQL
12 votes217 views5 answers
Rename table in mysql
SQL
0 vote214 views1 answer
Id INT NOT NULL AUTO_INCREMENT
SQL
0 vote205 views1 answer
Mysql count number of occurrences in a column
SQL