SmartSQL is a convenient and fast tool for querying and exporting database documents! This tool has been supporting the CHM document format since its inception, and through continuous exploration, brainstorming, and improvement, it has also gradually supported exporting document formats such as Word, Excel, PDF, HTML, XML, Json, MarkDown, etc. Simultaneously supporting document query and export functions for multiple databases such as SQLServer, MySql, PostgreSQL, SQLite, etc.

database support

✅ SqlServer
✅ MySQL
✅ PostgreSQL
✅ SQLite
☑️Oracle
☑️DB2
☑️TIDB
☑️dermal
☑️KingBase

major function

1 What does the document contain?

Table number | Column name | Primary key | Self increment | Data type | Length | Allow NULL value | Default value | Remarks
View View Content SQL Script
Stored Procedure Content SQL Script

2 What document formats are supported for export?

A convenient and fast tool for querying and generating database documents插图1

3 What are the ways to update table column comments?

By file➡Import comments, select file import to update annotations (comments):

PDM is generated when designing databases using PowerDesigner
XML is used by Visual Studio to set the project properties of entity libraries. When selecting the XML document file, it generates a project
XML is generated by exporting XML from SmartSQL

Tool usage

1 Database connection

In connection management, you can perform operations such as adding, deleting, and modifying the currently added connection
Currently supports support for four databases including SQL Server, MySQL, PostgreSQL, SQLite, etc
Regarding Oracle DB2、TIDB、 The support for other relational databases such as Dameng is also being intensively implemented

A convenient and fast tool for querying and generating database documents插图2

A convenient and fast tool for querying and generating database documents插图3

2 Group management

Here, custom grouping can be implemented for tables, views, stored procedures, and other objects in the database, facilitating subsequent management
At the same time, it also supports sorting groups. Place the mouse on the group that needs to be sorted, and when the mouse arrow changes, you can drag and sort it
Commonly used groups can be set to default expansion, and infrequently used groups can be set to default non expansion, keeping the left menu interface clean and refreshing

A convenient and fast tool for querying and generating database documents插图4

3 Quick Search

A convenient and fast tool for querying and generating database documents插图6

4 import/export

A convenient and fast tool for querying and generating database documents插图10

5 Settings/About

A convenient and fast tool for querying and generating database documents插图12

Document screenshot

CHM document

A convenient and fast tool for querying and generating database documents插图14

HTML document

A convenient and fast tool for querying and generating database documents插图16

—END—

Open source protocol：Apache2.0

资源下载此资源为免费资源立即下载

Telegram:@John_Software

collect(0) Like (0)

Disclaimer: This article is published by a third party and represents the views of the author only and has nothing to do with this website. This site does not make any guarantee or commitment to the authenticity, completeness and timeliness of this article and all or part of its content, please readers for reference only, and please verify the relevant content. The publication or republication of articles by this website for the purpose of conveying more information does not mean that it endorses its views or confirms its description, nor does it mean that this website is responsible for its authenticity.

Ictcoder Free source code A convenient and fast tool for querying and generating database documents https://ictcoder.com/kyym/a-convenient-and-fast-tool-for-querying-and-generating-database-documents.html

lllll

Share free open-source source code

Previous article： MarkText is a simple and elegant open-source Markdown editor

Next article： Real time API and application dashboard for Directus database content

Q&A

What is the delivery method?

1, automatic: after taking the photo, click the (download) link to download; 2. Manual: After taking the photo, contact the seller to issue it or contact the official to find the developer to ship.

View details

How long is the trading cycle?

1, the default transaction cycle of the source code: manual delivery of goods for 1-3 days, and the user payment amount will enter the platform guarantee until the completion of the transaction or 3-7 days can be issued, in case of disputes indefinitely extend the collection amount until the dispute is resolved or refunded!

View details

Matters needing attention

1. Heptalon will permanently archive the process of trading between the two parties and the snapshots of the traded goods to ensure that the transaction is true, effective and safe! 2, Seven PAWS can not guarantee such as "permanent package update", "permanent technical support" and other similar transactions after the merchant commitment, please identify the buyer; 3, in the source code at the same time there is a website demonstration and picture demonstration, and the site is inconsistent with the diagram, the default according to the diagram as the dispute evaluation basis (except for special statements or agreement); 4, in the absence of "no legitimate basis for refund", the commodity written "once sold, no support for refund" and other similar statements, shall be deemed invalid; 5, before the shooting, the transaction content agreed by the two parties on QQ can also be the basis for dispute judgment (agreement and description of the conflict, the agreement shall prevail); 6, because the chat record can be used as the basis for dispute judgment, so when the two sides contact, only communicate with the other party on the QQ and mobile phone number left on the systemhere, in case the other party does not recognize self-commitment. 7, although the probability of disputes is very small, but be sure to retain such important information as chat records, mobile phone messages, etc., in case of disputes, it is convenient for seven PAWS to intervene in rapid processing.

View details

Systemhere declaration

1. As a third-party intermediary platform, Qichou protects the security of the transaction and the rights and interests of both buyers and sellers according to the transaction contract (commodity description, content agreed before the transaction); 2, non-platform online trading projects, any consequences have nothing to do with mutual site; No matter the seller for any reason to require offline transactions, please contact the management report.

View details