SELECT   *
FROM     sysobjects
WHERE    sysobjects.type = 'U'
ORDER BY sysobjects.name

SELECT   syscolumns.name
         , *
FROM     syscolumns
JOIN     sysobjects ON syscolumns.id = sysobjects.id
WHERE    sysobjects.name = 'TABLE_NAME'
ORDER BY syscolumns.name