All field types, lengths, names of the tables that export the database

SELECT
(case if A.colorder=1 then d.name Else ' end) Table name,
A.colorder Field Ordinal,
A.name Field Name,
B.name field type,
b.length field Length,
G.[value] As Field description
From syscolumns a LEFT join systypes b
On A.xtype=b.xusertype
INNER JOIN sysobjects D
On a.id=d.id and d.xtype= ' U ' and d.name<> ' dtproperties '
Left Join Sys.extended_properties G
On a.id=g.major_id and a.colid = g.minor_id
--where D.[name] <> ' table_desc '--the name of the table you want to view, comment out, view field information for all tables in the current database
--where D.[name] = ' cityhot '-the table name you want to view, comment out, view field information for all tables in the current database
ORDER BY A.id,a.colorder

All field types, lengths, names of the tables that export the database