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