October 6, 2008 at 2:15 pm
Hello:
Is it possible to create a data dictionary for all the tables in a SQL database using a SQL script or T-SQL ??
Any ideas are welcome.
Thanks.
October 6, 2008 at 2:18 pm
Sure it is possible. You could use the information_schema and sys views.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
October 6, 2008 at 6:57 pm
Here is what I use to create a data dictionary using T-SQL.
November 30, 2010 at 4:04 pm
Here is part of what I do...
CREATE VIEW [dbo].[DataDictonary] AS
SELECT schemas.name AS SchemaName
,all_objects.name AS TableName
,syscolumns.id AS ColumnId
,syscolumns.name AS ColumnName
,systypes.name AS DataType
,syscolumns.length AS CharacterMaximumLength
,sysproperties.[value] AS ColumnDescription
,syscomments.TEXT AS ColumnDefault
,syscolumns.isnullable AS IsNullable
FROMsyscolumns
INNER JOIN sys.systypes ON syscolumns.xtype = systypes.xtype
LEFT JOIN sys.all_objects ON syscolumns.id = all_objects.[object_id]
LEFT OUTER JOIN sys.extended_properties AS sysproperties ON (sysproperties.minor_id = syscolumns.colid AND sysproperties.major_id = syscolumns.id)
LEFT OUTER JOIN sys.syscomments ON syscolumns.cdefault = syscomments.id
LEFT OUTER JOIN sys.schemas ON schemas.[schema_id] = all_objects.[schema_id]
WHERE syscolumns.id IN (SELECT id
FROM sysobjects
WHERE xtype = 'U')
AND (systypes.name <> 'sysname')
May 1, 2014 at 12:54 am
June 16, 2014 at 10:08 pm
Hi,
Please let me know the free download version from this site will work how many days and what are limitations?
June 16, 2014 at 11:30 pm
Bruce Dunwiddie (5/1/2014)
I use http://www.sqldatadictionary.com/ .
Hi,
Please let me know the free download version from this site will work how many days and what are limitations?
June 12, 2015 at 11:09 am
We use Dataedo, it has nice output, you can format text and paste images and group objects into logical "modules".
Viewing 8 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy