Just found out that THE way to do it is to call sp_columns.

ie

exec sp_columns 'tablename'

in Query Analyzer grid view