Learn how to use the SQL Server to filter the database table names.
To filter the table names in a database:
- In the Object Explorer, select a database and expand its contents.
- Select the Tables category.
- In the Object Explorer toolbar, click
(Filter).
- The Filter Settings window appears. Here you have a series of criteria that you can use for filtering the table names.
- Set the desired criteria and click OK to save and exit.
The list of tables will be filtered to show only the tables that fit the criteria set in the settings window, and the Tables category name switches to Tables (filtered) in the Object Explorer.