![]() ![]() In addition to writing SELECT queries to search for a specific value, SQL Server Management Studio provides us with another way to search for column values and modify them directly at the database object level based on the specified criteria. ![]() To remove the filter and view all the database objects again, right-click on the relevant database objects list node, which is the Tables node in our example, and choose the Remove Filter option from the Filter options list, and all database objects will be displayed again, as shown below:ĭata Search in SQL Server Management Studio Once the filter is applied, you will see that only the database objects that meet the filter search criteria will be listed under the objects type node, as shown below: After specifying the filter criteria, click OK to apply the filter: For example, you can search for a database object with the name equals to, containing or not containing the provided value. name, schema or the owner of that object, the operator that will be used in the search filter).
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |