This is especially useful if you have lots of related tables and your only interested in a particular set of them e.g. every table with "user" in the table name.
- Right click on the tables folder
- Choose Filter > Filter settings
- This brings up a dialog window allowing you to choose your search criteria (only simple criteria can be user e.g. name, owner, so you cannot use OR/AND etc).
- After clicking enter your tables are filtered (in the example by all table names with the word "user" in them).
- Happy developer
This example is in Sql Server Management Studio 2008 R2 (but it should work in 2005 and perhaps lower).