Returning metadata information about SQL Server objects is a common task.  For example, you may want to list all of the tables in a database, or find the stored procedures that reference a certain table or column.  This kind of information is available through catalog views and functions, but it can be confusing if you're not sure which of these returns the metadata information you want.  This article provides example queries that you can use to quickly return the information you need.

Tables, Indexes, Views, and Constraints