/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

4 votes280 views4 answers
Oracle tablespace tables list
SQL
0 vote280 views1 answer
What is between keyword used for
SQL
10 votes284 views6 answers
Sql between
SQL
0 vote318 views1 answer
Psql check if sql script is valid
SQL
1 vote300 views2 answers
Sql server backup table
SQL
0 vote287 views1 answer
Sql out file formate
SQL
0 vote270 views1 answer
Create relationship with betwen two tables in postgersql
SQL
4 votes264 views1 answer
Oracle delete last row
SQL
0 vote269 views1 answer
T sql less than date
SQL
3 votes287 views1 answer
Postgres kill running query
SQL