SELECT c.name
FROM   sysobjects o
JOIN   syscolumns c
  ON   o.ID = c.ID
WHERE o.name ='MyTable'