Obtain valid information such as description and table name of each SQL Field

 

Select sysobjects. Name as tablename, syscolumns. ID, syscolumns. Name as name,
Policypes. Name as type, syscolumns. length as size,
SYS. extended_properties. [value] As columndesc, syscomments. Text
Column_default, syscolumns. isnullable as is_nullable from syscolumns
Inner join policypes
On syscolumns. xtype = policypes. xtype
Left join sysobjects on syscolumns. ID = sysobjects. ID
Left Outer Join SYS. extended_properties on
(SYS. extended_properties.minor_id = syscolumns. colid
And SYS. extended_properties.major_id = syscolumns. ID)
Left Outer Join syscomments on syscolumns. cdefault = syscomments. ID
Where syscolumns. ID in
(Select ID from sysobjects where xtype = 'U') and (policypes. Name <> 'sysname ')
Order by syscolumns. colid