Filtering and Searching Database Objects

www.altova.com Print this Topic Previous Page Up One Level Next page

Home >  Data Sources and Targets > Databases and MapForce > Browsing and Querying Databases > Browsing Database Objects >

Filtering and Searching Database Objects

You can filter any database objects (schemas, tables, views, etc) displayed in the Database Browser by name or part of a name. Objects are filtered as you type in the characters. Filtering is case-insensitive by default. Filtering is not supported if you have selected the "No Folders" layout.

 

Filtering database objects

1.At the top of the Database Browser, click Filter Folder contents ( ic_filter ). Filter icons appear next to all folders in the currently selected layout.

dbq-brow2

2.Click the filter icon next to the folder you want to filter, and select the filtering option from the context menu (for example, Contains).

mnu-filter

3.In the empty field which appears next to the filter icon, enter the search text (for example, "G"). The results are adjusted as you type.

dbq-brow3

 

Searching database objects

To find a specific database item by its name, you can either use filtering functions or the Object Locator. To find database elements using the Object Locator:

 

1.At the top of the Database Browser, click Object Locator ( ic_object-locator ) .
2.In the drop-down list that appears, enter the search text (for example, "Off").

db_browser_search

3.Click an object in the list to select it in the Database Browser.

© 2019 Altova GmbH