/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 vote136 views1 answer
Insert data from stored procedure into table
SQL
1 vote197 views1 answer
Connect to mysql database ubuntu
SQL
0 vote142 views1 answer
Sql change default collation to utf8
SQL
13 votes198 views3 answers
Mysqldump structure only
SQL
0 vote188 views1 answer
Mysql could not fetch tables
SQL
0 vote152 views1 answer
Difference between 2 query results sql server
SQL
0 vote140 views1 answer
Postgres copy command
SQL
0 vote146 views1 answer
Linebreak sql
SQL
0 vote150 views1 answer
Oracle running queries sql
SQL
7 votes135 views3 answers
Postgresql dump and restore db
SQL