SELECT o.name Table_Name, c.name Column_Name, t.name DataType, c.Length, CASE WHEN c.isnullable=1 THEN 'Yes' ELSE 'No' END AS 'Nullable'

FROM sysobjects o

INNER JOIN syscolumns c ON (o.id=c.id and o.type='U' and o.name not like 'dt%')

Inner Join systypes t ON (c.xtype=t.xtype)

WHERE t.name<>'sysname'

order by o.name, c.colorder