/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 vote165 views1 answer
Acutal month year
SQL
10 votes220 views6 answers
Mysql set root password
SQL
6 votes174 views1 answer
Update left join mysql
SQL
2 votes171 views1 answer
Oracle virtual column
SQL
5 votes169 views2 answers
Mysqldump password
SQL
0 vote173 views1 answer
Sql contains vs like
SQL
4 votes303 views1 answer
What are the data types
SQL
-2 votes183 views3 answers
Sqlite reset autoincrement
SQL
0 vote157 views1 answer
Cara menampilkan user di mysql terminal
SQL
3 votes176 views1 answer
Create a table with an id in mysql
SQL