Data Dictionary for my Database

• SQL Prog

  SSCrazy

  Points: 2020

  More actions

  December 7, 2011 at 1:36 pm

  #261077

  Hello All,

  I am assigned to create a data dictionary for the database. Does anyone has the template that would help me?..Please assist..

  Thanks

• Eric

  SSCommitted

  Points: 1803

  More actions

  December 7, 2011 at 1:59 pm

  #1418369

  The Kimball group has some templates.

  http://www.kimballgroup.com/html/booksMDWTtools.html

  See the download under "Chapter 2 — Designing the Business Process Dimensional Model" / "Dimensional modeling spreadsheet"

  This spreadsheet has macros to generate DDL scripts, which you might not need, but you can see the kind of information they capture in their documentation.