Quick Search SQL Server Object

Create Procedure SOS
(
    @ObjectName    VarChar(Max),
    @Object        Char(1) = 'P'
)
As
Begin
    /*
        Execution:    SOS b,p
    */
    Set NoCount On
   
    If Upper(@Object) =  'T' --// Table
        select name 'Table' from sysobjects where xtype = 'U' And name like '%' + @ObjectName + '%'
        order by name
    Else If Upper(@Object) =  'V' --// View
        select name 'View' from sysobjects where xtype = 'V' And name like '%' + @ObjectName + '%'
        order by name
    Else If Upper(@Object) =  'P' --
        select name 'Procedure' from sysobjects where xtype = 'P' And name like '%' + @ObjectName + '%'
        order by name
    Else If Upper(@Object) =  'F' --
        select name 'Function' from sysobjects where xtype = 'FN' And name like '%' + @ObjectName + '%'
        order by name
End



The above Procedure helps to quick search for SQL Server Objecs at developing

For Eg,

SOS 'Master'

It Returns Procedure names that contains searched value.

Result :
--------------
spEmployeeSave
SpEmployeeGet
spEmployeeDelete

SOS 'Master',T

It Returns Table names that contains searched value.

Result :
--------------
EmployeeMaster

SOS 'Master',V

It Returns view names that contains searched value.

Result :
-------------
viEmployee


SOS 'Master',F

It Returns function names that contains searched value.

Result
------
fnEmployeeCodeGet