Cacher is the code snippet organizer for pro developers

select
	dbo.sysobjects.name TableName, 
	dbo.syscolumns.name ColumnName, 
	dbo.systypes.name as Type
from dbo.sysobjects 
join dbo.syscolumns on dbo.syscolumns.id = dbo.sysobjects.id 
join dbo.systypes on dbo.systypes.xtype = dbo.syscolumns.xtype
where dbo.systypes.name != 'sysname'