search in the data using objectname

Solutions on MaxInterview for search in the data using objectname by the best coders in the world

showing results for - "search in the data using objectname"
Claudio
28 Jun 2020
1declare @ObjectName nvarchar(max)='objectName'
2SELECT  o.[name] as object_name
3                                                            , sm.[definition]
4                                                    FROM sys.sql_modules AS sm
5                                                    JOIN sys.objects AS o
6                                                        ON sm.object_id = o.object_id
7                                                    JOIN sys.schemas AS ss
8                                                        ON o.schema_id = ss.schema_id
9where o.name=@ObjectName
similar questions
queries leading to this page
search in the data using objectname