pirica/hta-db-schema

Document DB Schema for Oracle (using hta script)

hta-db-schema

Document DB Schema for Oracle/MySQL (using hta script)

This is a simple hta script to show/document oracle tables/views.

• For Oracle, it use OLEDB (driver=MSDAORA)
• For MySQL, it use ODBC for MySQL

no more dependance.

Features

1. single hta scripting file
2. no dependance without any css/js lib
3. document oracle/mysql using built-in "comments" feature.
4. classify tables/views into "folder"
5. show/edit/print table summary (for classified table/view only)
6. show/edit/print table definition

Usage Guide

just download file db-schema-oracle.hta or db-schema-mysql.hta to local, and click to run.

1. input the oracle database connection parametes, and click "connect" button
2. by default, tables/views will show in folder of "TABLE/VIEW" in grey color
3. click on folder to toggle table list
4. click on table to show table definition
5. DoubleClick on table description to edit (and setup folder)
6. DoubleClick on column description to edit (ps: for oracle only!)
7. Click "print" button to print table definition
8. input keyword and press enter (or click on "search" button) to search name+comments

You may edit below script (bottom of file, line 262) to setup the default DB connection.

  //===== initial db connection parameters =====
  app('dbtitle').value = 'Database Schema of Oracle DB'
  app('dbserver').value = '192.168.0.211'
  app('dbname').value = 'XE'
  app('dbuser').value = 'hr'
  app('dbpass').value = 'password'
  //app.connectdb()
  //===== end of db parameters ====================

For MySQL,

  //===== initial db connection parameters =====
  app('dbtitle').value = 'Database Schema of MySQL'
  app('dbodbc').value = 'MySqlDsn'
  //app.connectdb()
  //===== end of db parameters ====================

Modification Log

• 2022/07/06, v0.70, initial version, for Oracle DB
• 2022/07/11, v0.80, add MySql version