/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

3 votes119 views1 answer
Postgres count distinct
SQL
0 vote113 views1 answer
Oracle execute package dblink
SQL
5 votes119 views2 answers
Oracle list columns schema
SQL
0 vote124 views1 answer
Mysql insert into select transaction c#
SQL
1 vote115 views2 answers
Sql server find all foreign keys that reference a column
SQL
1 vote121 views1 answer
Sql server epoch to datetime
SQL
0 vote146 views1 answer
Get total and distict row diff in sql
SQL
0 vote116 views3 answers
Mysqli count down
SQL
9 votes141 views3 answers
Date format in sql
SQL
0 vote68 views1 answer
Update row in sqlite python
SQL