This was awesome once i figured out i had to drop the schema.table name syntax from

select c.name, c.xtype, c.status

from syscolumns c

inner join sysobjects o

on o.id = c.id

where o.name = 'CalendarCountry'

and o.xtype in ('U', 'S')

order by ColID

just a fyi