DBA Utility Belt: Searching Metadata

When you're looking for something in a database, there are a few key metadata tables which can help you out. First, suppose you're searching for a table name: Or maybe by column name: Something I use very often is searching within all stored procedures and views for a particular column name. This query searches the…

Advertisement