/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

1 vote160 views1 answer
Psql datetime grather than
SQL
12 votes194 views1 answer
Create column sql server
SQL
2 votes164 views1 answer
Oracle virtual column
SQL
0 vote180 views1 answer
Postgresql array to rows
SQL
48 votes272 views3 answers
Psql create database
SQL
1 vote216 views2 answers
List tables sqlalchemy
SQL
2 votes156 views1 answer
Mysql auto increment jumping
SQL
0 vote169 views2 answers
Sql server Insert Into table
SQL
0 vote215 views1 answer
What does the -p flag do in mysql cli
SQL
0 vote201 views1 answer
Install postgresql 12 on debian 10
SQL