/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 vote146 views1 answer
Psql use query result convert Decimal python numpy psycopg2
SQL
0 vote114 views1 answer
Import sql file in mysql linux
SQL
0 vote164 views2 answers
Reseed sql identity
SQL
7 votes142 views3 answers
Postgresql dump and restore db
SQL
0 vote170 views1 answer
Postgresql conectar
SQL
5 votes143 views1 answer
Postgresql functions
SQL
0 vote154 views1 answer
Mysql create index lost connection
SQL
4 votes142 views1 answer
Sql group by year
SQL
0 vote114 views1 answer
Mysql collation for all languages
SQL
0 vote134 views1 answer
Mariadb set vertical output format
SQL