Menu
In Management Studio, you can right click on the tables group to create a filter for the table list. Has anyone figured out a way to include multiple tables in the filter? For example, I'd like all tables with "br_*" and "tbl_*" to show up.
Anyone know how to do this?
465
To filter rows by using a list: Type: SELECT columns FROM table WHERE test_column [NOT] IN (value1, value2,...); columns is one or more comma-separated column names, and table is the name of the table that contains columns.
The SQL filter syntax supports the AND, OR and NOT boolean operators.
The IN operator allows you to specify multiple values in a WHERE clause. The IN operator is a shorthand for multiple OR conditions.
In Management Studio, you can right click on the tables group to create a filter for the table list. Has anyone figured out a way to include multiple tables in the filter? For example, I'd like all tables with " br_* " and " tbl_* " to show up. Anyone know how to do this? No, you can't do this.
SQL – SELECT from Multiple Tables with MS SQL Server. In SQL we can retrieve data from multiple tables also by using SELECT with multiple tables which actually results in CROSS JOIN of all the tables. The resulting table occurring from CROSS JOIN of two contains all the row combinations of the 2nd table which is a Cartesian product of tables.
In databases that have many objects, you can use filtering to search for specific tables, views, etc. This section describes how to filter tables, but you can use the following steps in any other node in Object Explorer: Connect to your SQL server. Expand Databases > AdventureWorks > Tables. All the tables in the database appear.
Connect to your SQL server. Expand Databases > AdventureWorks > Tables. All the tables in the database appear. Right-click Tables, and then select Filter > Filter Settings: In the Filter Settings window, you can modify some of the following filter settings: Filter by name: Filter by schema:
No, you can't do this. When we first got Management Studio I've tried every possible combination of everything you could think of: _, %, *, ", ', &&, &, and, or, |, ||, etc...
68
You might be able to roll your own addon to SMSS that would allow you to do what you are looking for:
The Black Art of Writing a SQL Server Management Studio 2005 Add-In
Extend Functionality in SQL Server 2005 Management Studio with Add-ins
The first one is specifically for searching and displaying all schema objects with a given name so you might be able to expand upon that for what you are looking for.
21
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
