- SQL Server 2016
- C# Scripts
- DWH INTERVIEW QUESTIONS
- MS Dynamics AX 2012 R2 Video Tutorial
- Project / Work Support
- SQL SERVER DBA INTERVIEW QUESTIONS
- SQL SERVER DBA Video Tutorial
- SQL Server / TSQL Tutorial
- SQL Server Scripts
- SSIS INTERVIEW QUESTIONS
- SSIS Video Tutorial
- SSRS INTERVIEW QUESTIONS
- SSRS Video Tutorial
- TSQL INTERVIEW QUESTIONS
- Team Foundation Server 2013 Video Tutorial
- Team Foundation Server 2015 Video Tutorial
- Windows 10
- Windows Server 2012 R2 Installation Videos
How to Filter Objects in SQL Server Management Studio (SSMS) - SQL Server / TSQL Tutorial Part 19
SQL Server Management Studio(SSMS) let us filter objects such as tables. Stored Procedure and Views. It really helps to get to object quickly in case when you have a lot of objects in your single database.
Here is how you can filter the objects. Go to Database and then to Tables, Views or Stored Procedures under Programmability and then Right click.
How to filter objects in SQL Server Management Studio- SQL Server Tutorial
In next windows, we will be able to provide filter criteria. We can filter when equal, contains or not equal as you can see below.
How to filter objects( tables, views and Stored Procedures) in SSMS - SQL Server Tutorial
Once filter is applied, you will see only object which qualify filter criteria.
How to find object quickly in SSMS- SQL Server Tutorial Step by Step
Once you are done and would like to see all the object again or change filter criteria, Right Click on Tables, Views or Stored Procedures and then go to Filter and then hit Remote Filter or Filter Setting to change current criteria.
How to remove Filter setting in SSMS For objects - SQL Server Tutorial for Beginners