/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 votes224 views1 answer
For loop postgresql
SQL
0 vote221 views1 answer
Mysql query to check record exists in database table or not
SQL
0 vote216 views1 answer
Oracle list subpartitions
SQL
1 vote215 views1 answer
Sql list all procedures
SQL
1 vote222 views1 answer
List all triggers in SQL Server
SQL
0 vote203 views1 answer
Generate random & unique mysql string
SQL
0 vote250 views1 answer
Finding leap year in sql
SQL
0 vote272 views1 answer
Osm2pgsql mac
SQL
0 vote240 views1 answer
Cube oracle
SQL
6 votes229 views2 answers
Mysql execute file
SQL