We have a lot of tables and views in one database. I would like to be able to type into the drop down to get myself quickly to the range of tables I am looking for.
For example we have a set that are prefixed with sis_
But when I try, I get seemingly random results. Is there a fast way to get near what I want with the keyboard?
By typing the starting letter you can walk through the list of items that start on that letter. The problem is that table names in this list include schema names as a prefix, so if all of them are in dbo you will not have much use of typing the starting letter. Having logical schemas could help you navigate through the list. Thanks,
Have you tried using DSVs for defining subset of tables you want to deal with? That should be helpful too.
Bob Bojanic wrote:
Having logical schemas could help you navigate through the list.
Have you tried using DSVs for defining subset of tables you want to deal with?
Okay, I added a DSV for the tables I use most often, but I don't see how to get a connecting manager connected to a DSV.
When adding the connection manager choose "New Connection From Data Source..." menu item and then choose the Data Source your DSV is based on. HTH. Thanks,
Then, open the adapter UI (i.e. OLE DB Source Editor), drop down the list of connections and pick up your DSV from the tree (it will be a child node).
