Solved

Database Dictionary

Posted on 2010-11-30
7
396 Views
Last Modified: 2012-05-10
Does anyone happened to have a script that will help with database dictionary?
0
Comment
Question by:Favorable
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
7 Comments
 
LVL 39

Accepted Solution

by:
BrandonGalderisi earned 500 total points
ID: 34242297
Do you mean to document your schema?
0
 

Author Comment

by:Favorable
ID: 34313632
Yes to document all datatbase schema.
0
 
LVL 39

Assisted Solution

by:BrandonGalderisi
BrandonGalderisi earned 500 total points
ID: 34330538
I use SQL Doc, by Red-Gate software.  It works by adding extended database properties into MS_Description.
0
The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

 

Author Comment

by:Favorable
ID: 34335221
Does your company pays for it and what is the cost?
0
 
LVL 39

Assisted Solution

by:BrandonGalderisi
BrandonGalderisi earned 500 total points
ID: 34340674
For JUST SQL Doc is $295 per user.  And if I asked yes my employer would pay for it.
0
 

Author Comment

by:Favorable
ID: 34348608



I need a t-sql query that will help to retrieve a particular table information in database like the following:



TableName, Column Names, Type, Length, Nullable
   



Also, to retrieve user stored procedure, Views, and Function.

I'm using these for my database documentation.






 


0
 
LVL 39

Assisted Solution

by:BrandonGalderisi
BrandonGalderisi earned 500 total points
ID: 34356015
SELECT c.TABLE_NAME,c.COLUMN_NAME,c.DATA_TYPE,c.CHARACTER_MAXIMUM_LENGTH,c.IS_NULLABLE
FROM INFORMATION_SCHEMA.COLUMNS c

SELECT r.ROUTINE_NAME,r.ROUTINE_TYPE,r.DATA_TYPE
FROM INFORMATION_SCHEMA.routines r
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I have written a PowerShell script to "walk" the security structure of each SQL instance to find:         Each Login (Windows or SQL)             * Its Server Roles             * Every database to which the login is mapped             * The associated "Database User" for this …
There have been several questions about Large Transaction Log Files in SQL Server 2008, and how to get rid of them when disk space has become critical. This article will explain how to disable full recovery and implement simple recovery that carries…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question