Returns the datatype, table name and field name for all user tables in the current SQL Server 2005 database. Results are sorted by type, table and field.
--returns all fields sorted by datatype
select t.name as 'type', o.name as 'table', c.name as 'field' from
sys.columns c, sys.objects o, sys.types t
where o.type='U' and c.object_id = o.object_id and c.system_type_id =
order by t.name, o.name, c.name