Create Data Dictionary By Query

This is a query that use for generate your simple data
dictionary.


Sample

select   distinct syscolumns.name,systypes.name as Type,
        syscolumns.length,sysproperties.value    
From     syscolumns
         inner join sysobjects on sysobjects.id=syscolumns.id
        left outer join sysproperties on
        sysproperties.smallid=syscolumns.colid
         and sysproperties.id = syscolumns.id
         inner join systypes on
        syscolumns.xtype = systypes.xtype
where  sysobjects.name='TableName'