![]() Including SSAS management, and MDX, DMX, and XMLA languagesĬ++/ C# Objective-C Python (programming language) Sybase, IBM Db2, H2, Hypersonic SQL, Amazon Redshift, Apache Derby, Redis, MongoDB, Snowflake, Exasol, BigQuery, Cassandra, ClickHouse, CockroachDB, CouchbaseĮXASOL, IBM Db2, Apache Derby, Firebird all with JDBC driver InterBase, Firebird, SQL Anywhere, NexusDB and MariaDB ![]() Systems listed on a light purple background are no longer in active development. This article is neither all-inclusive nor necessarily up to date. Please see individual product articles for further information. Monitoring PostgreSQL with Navicat Monitor 3.The following tables compare general and technical information for a number of available database administration tools.Trace Queries on your PostgreSQL Instances with Navicat Monitor 3. ![]() Viewing PostgreSQL Instance Details in Navicat Monitor 3.A Quick Guide to Naming Conventions in SQL - Part 2.A Quick Guide to Naming Conventions in SQL - Part 3.Selecting Distinct Values From a Relational Database.Implement Audit Trail Logging Using Triggers.Multi-Version Concurrency Control in PostgreSQL.A Guide to MySQL Foreign Key Constraints.Navicat Wins a DBTA Readers' Choice Award!.Joining Database Tables on Non-Foreign Key Fields.Navicat 16.3 Adds Support for Redis Cluster.What Sets Redis Apart from Other Databases.Understanding Navicat Connection Profiles.Choosing Between Redis and a Traditional Relational Database.Measuring Query Execution Time in Relational Databases.You can learn more about Navicat Premium's features on the product page. Compared with the alternative of information_schema schema, there is really no contest. Navicat's Find in Database/Schema tool greatly facilitates finding data or object structures within an entire database or schema. Notice the query that Navicat generated to fetch the desired results. Here's the results for a "Find what" value of "JOHN" with "Prefix" selected from the "Search Mode" drop-down:Īs you can see, this more general search resulted in more matches.Īgain, double-clicking an object in the Find Results list displays the record(s) in a new tab: In Navicat, all we need to do is follow the same process as above, except that now we'll select "Data" from the "Look in" drop-down. Trying to find a given value within the entire database without a search tool is scarcely worth the trouble. You can double-click an object in the Find Results list to view the record or the structure. In this case Navicat matched the "release_year" column in one table: Now, go ahead and click the Find button to obtain the results.Here is what the form should look like with all of the fields filled in and/or selected: Since we selected "Structure" in the "Look in" drop-down list, we can now choose to search different objects, including Tables, Views, Functions, Queries, and/or Events.Check the "Case Insensitive" box to disable case sensitive search.Choices include Contains, Whole Word, Prefix or Regular Expression. Choose the "Structure" item in the "Look in" drop-down list.Enter the search string in the "Find what" text box. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |