select col.name as ColName, obj.name as TableName, typ.name as DataType
from syscolumns col, systypes typ, sysobjects obj
where col.xtype = typ.xtype
and col.id = obj.id
and typ.xtype = 59
and obj.xtype = 'U'
order by obj.name, col.name
xtype 59 is datatype real. You can find data type code from systypes table.
Edited by - Allen_Cui on 03/25/2003 2:01:06 PM