SQL Server - Cómo generar Diccionario de Datos en SQL Server 2008

SELECT

    t.name AS Tabla,

    c.name as Campo,

    tp.name + '(' + CAST(TP.max_length AS VARCHAR) + ')' AS 'Tipo de Campo',

    ep.value as Comentario,

    (CASE

        WHEN c.is_nullable = 0 THEN 'SI'

        WHEN c.is_nullable = 1 THEN 'NO'

    END) AS 'NULL'

FROM sys.tables t

    inner join sys.columns c

        on t.OBJECT_ID = c.OBJECT_ID

    inner join sys.types tp

        on c.user_type_id = tp.user_type_id

    left join sys.extended_properties ep

		on (t.object_id=ep.major_id and

			c.object_id=ep.minor_id)

where t.name='Mi_Tabla'

ORDER BY T.name, C.name

select a.name [Table],b.name [Attribute],c.name [DataType],b.isnullable [Allow Nulls?],CASE WHEN

d.name is null THEN 0 ELSE 1 END [PKey?],

CASE WHEN e.parent_object_id is null THEN 0 ELSE 1 END [FKey?],CASE WHEN e.parent_object_id

is null THEN '-' ELSE g.name  END [Ref Table],

CASE WHEN h.value is null THEN '-' ELSE h.value END [Description]

from sysobjects as a

join syscolumns as b on a.id = b.id

join systypes as c on b.xtype = c.xtype

left join (SELECT  so.id,sc.colid,sc.name

      FROM    syscolumns sc

      JOIN sysobjects so ON so.id = sc.id

      JOIN sysindexkeys si ON so.id = si.id

                    and sc.colid = si.colid

      WHERE si.indid = 1) d on a.id = d.id and b.colid = d.colid

left join sys.foreign_key_columns as e on a.id = e.parent_object_id and b.colid = e.parent_column_id

left join sys.objects as g on e.referenced_object_id = g.object_id

left join sys.extended_properties as h on a.id = h.major_id and b.colid = h.minor_id

where a.type = 'U' order by a.name

select	a.name [ENTIDAD],

		b.name [CAMPOS],

		c.name + '(' + CAST(c.length AS VARCHAR) + ')' AS [TIPO DE DATO],

		case when b.isnullable=0 then 'NO' else 'SI' end [NULL],

		case when d.name is null then '' else 'X' end [PK],

		case when e.parent_object_id is null then '' else 'X' end [FK],

		case when h.value is null then '' else h.value end [DESCRIPCIÓN]

from	sysobjects as a

		join syscolumns as b

			on a.id = b.id

		join systypes as c

			on b.xtype = c.xtype

		left join	(SELECT       so.id,

							sc.colid,

							sc.name

					 FROM	syscolumns sc

							join sysobjects so

								on so.id = sc.id

							join sysindexkeys si

								on so.id = si.id and

									sc.colid = si.colid

					 WHERE si.indid = 1) d

			on	a.id = d.id and

				b.colid = d.colid

		left join sys.foreign_key_columns as e

			on	a.id = e.parent_object_id and

				b.colid = e.parent_column_id

		left join sys.extended_properties as h

			on	a.id = h.major_id and

				b.colid = h.minor_id

where a.type = 'U'

order by a.name

SELECT d.definition

FROM sys.default_constraints AS d

INNER JOIN sys.columns AS c

ON d.parent_column_id = c.column_id