Connections Pooled: Enables connection pooling.Fetch Size: determines the Fetch Size (number of rows physically retrieved from the database at one time by the JDBC driver).Only display databases that user has access to: Displays only the databases the current user (from the Login Name on the General tab) has access to within the schema browser.Enable db filters for query window: enables/disables db filters for query windows using this connection.TRANSACTION_SERIALIZABLE - A constant indicating that dirty reads, non-repeatable reads and phantom reads are prevented. TRANSACTION_REPEATABLE_READ - A constant indicating that dirty reads and non-repeatable reads are prevented phantom reads can occur. TRANSACTION_READ_UNCOMMITTED - A constant indicating that dirty reads, non-repeatable reads and phantom reads can occur. TRANSACTION_READ_COMMITTED - A constant indicating that dirty reads are prevented non-repeatable reads and phantom reads can occur. TRANSACTION_NONE - A constant indicating that transactions are not supported. Txn Isolation Level: Support for setting Transaction Isolation Level.With options in Advanced properties of a Server, you can :Įnable Database 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 databases 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 dropdown 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, etc. Object Folder filter works on individual folders inside a particular database. Example folders: Tables, View, Procedures, etc. Reconnect to see the changes.įilter Databases works on the list of databases inside the "Databases" folder.įilter Folders works on the list of folders inside a particular database. 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. Default Folders are Tables, System Tables, Views, Indexes, Triggers, Procedures, Functions. You can Create, Edit or Delete Object Folders.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |