Usually I just want columns to set up my insert queries so I use:

select sc.name from sysobjects so, syscolumns sc where

so.id = sc.id

and upper(so.name) = 'tablename' order by sc.colid;

If...