Solved

Database Dictionary

Posted on 2010-11-30
7
392 Views
Last Modified: 2012-05-10
Does anyone happened to have a script that will help with database dictionary?
0
Comment
Question by:Favorable
  • 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
Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

 

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

Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Params not declared?  T-SQL syntax question 3 40
Caste datetime 2 52
DATETIMEOFFSET feature 1 33
Help with simplifying SQL 6 51
In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Internet Business Fax to Email Made Easy - With  eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, f…
Both in life and business – not all partnerships are created equal. As the demand for cloud services increases, so do the number of self-proclaimed cloud partners. Asking the right questions up front in the partnership, will enable both parties …

863 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

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now