With options in Advanced properties of a Server, you can:Įnable Project Filters in Query Analyzer. Go to the Advanced Tab and make changes in the Options. Right-Click on the Server - A Popup Menu Appears. Then, there is an "Object Folder" filter on the Tables folder, which excludes everything except those that start with "forum".Įdit the Server Properties to use Advanced Properties in Aqua Data Studio: This is similar to the above example where all schemas, except the XXPKD schema, are excluded. The filter shown below is set to exclude all projects except those that start with "aq". Also, note that the filter pattern is case sensitive. Note the "+" in front of the XXPKD pattern. If your intention is to show only the tables that start with XXPKD, then you'll need to change your main filter to "Exclude All", and secondary filter to "+XXPKD*". Using the drop-down at the top of the Filter Tab, quickly change your Schema or Folder View. The user can define filters for each of the Tables, Views folders. Object Folder filter works on individual folders inside a particular dataset. Reconnect to see the changes.įilter Projects works on the list of projects inside the "Projects" folder.įilter Folders works on the list of folders inside a particular dataset. Use options to INCLUDE or EXCLUDE all Schemas and Folders.Įnter the Schema or Folder name in the specified text area and Press OK. Sometimes you would like to view only specific Schemas. You can Create, Edit or Delete Object Folders. Exclude Objects: A list of objects to exclude after the main filter is applied.Include Objects: A list of objects to include after the main filter is applied.Filter Objects: Allows the user to specify the main schema browser filter for object types, on whether to include or exclude all.Exclude Filter Projects: A list of Projects/datasets to exclude after the main filter is applied.Include Filter Projects: A list of Projects/datasets to include after the main filter is applied.
0 Comments
Leave a Reply. |