Simple search the whole database

databases

Search throughout the database – MSSQL

If we’ve got large database and we need to find some procedure or view. And we do not remember what it was called but we know what string or parameters it return or contains.
We can search our database for a simple query.

As a result, we get the names of views/procedures that contain our keyword.
search sql

Of course we can clearly specify what we are looking for then we will get more narrow results.

One Comment on “Simple search the whole database”

Dodaj komentarz

Twój adres email nie zostanie opublikowany. Pola, których wypełnienie jest wymagane, są oznaczone symbolem *