SQL Server obtains all tables, comments, and field attributes.

Retrieve table information

 

Select Sysobjects. Name, SYS. extended_properties.value From Sysobjects
Left   Join SYS. extended_properties On Sysobjects. ID = SYS. extended_properties.major_id
Where Type =   ' U '   And SYS. extended_properties.minor_id = ' 0 '   Order   By Name

 

 

Retrieve Field Information

 

Select Syscolumns. Name, syscolumns. length, policypes. Name As Tname, SYS. extended_properties. [ Value ]   As Tname, syscolumns. isnullable From Syscolumns
Join Policypes On Syscolumns. xtype = Policypes. xtype And Policypes. Name <>   ' Sysname '  
Left   Outer   Join SYS. extended_properties On  
(SYS. extended_properties.minor_id = Syscolumns. colid
And SYS. extended_properties.major_id = Syscolumns. ID)
Where Syscolumns. ID In  
( Select ID From Sysobjects Where Name =   ' Orderform ' )