16 feb 2010

find used colums or functions in sql database

you have wrote your own function in several views or stored procedures, but you don't know anymore where you have used it? it can be difficult to find them.

i did it my way :

  1. open Microsoft Sql Server Management studio
  2. select the target database
  3. right click => tasks=> Generate scripts
  4. Select the database and press next
  5. select where you want to search in for example views and tabels and pess next
  6. presss select all to select all tables and press next
  7. press selet all to select all viewss and pres next
  8. choose for example "script to new query window"
  9. press next and finish.
does anyone has another or better idea?

Geen opmerkingen:

Een reactie posten