Skip to content

Latest commit

 

History

History
12 lines (8 loc) · 560 Bytes

README.md

File metadata and controls

12 lines (8 loc) · 560 Bytes

SQL Database Dictionary

A database design for storing additional information (metadata), about a SQL database and the database schemas, tables, columns etc.

This information can then be used for reporting on the database and in applications viewing and editing the data.

Installation

  1. Create a database named 'dictionary' for storing database metadata
  2. Run the SQL scripts in the /ddl to create tables
  3. Run the SQL scripts in the /dml/add_new to create stored procedures (proc files)
  4. Run the SQL script /dml/call_procedures.sql to call procs