![]() Enable DB Filters for Query Window: Enables/Disables db filters for query windows using this connection.Always Display Column Name in Results: Allows to show/hide column names in query results.Display System Folders: Allows to show/hide System Tables in Tables.JDBC Escape Processing: Allows JDBC driver to perform escape sequence before sending the SQL code to the server.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 Isolation Level: Support for setting Transaction Isolation Level - TRANSACTION_NONE - A constant indicating that transactions are not supported.Enable Database Filters in Query Analyzer.With options in Advanced properties of a Server, you can: Go to the Advanced Tab and make changes in the Options. ![]() Click the Item which displays Server Properties.Right-click the Server - A Popup Menu Appears.Locate the Server in the Server Browser.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 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, etc.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |