/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 vote149 views1 answer
Drop-toys-table
SQL
0 vote155 views1 answer
Sql select all records from all tables where not empty
SQL
6 votes155 views3 answers
Mysql create database utf8
SQL
1 vote145 views1 answer
Right outer vs left outer join
SQL
3 votes170 views3 answers
Illuminate database queryexception could not find driver (sql select * from
SQL
3 votes148 views2 answers
Sql end of month
SQL
0 vote154 views1 answer
Mysqlimport
SQL
0 vote160 views1 answer
Neo4j command to run script file
SQL
0 vote152 views1 answer
Sqlite referential integrity
SQL
3 votes139 views1 answer
How to remove characters from string in mysql
SQL