sql: get table column names

use [db]

select o.name, c.name
from sysobjects o, syscolumns c
where o.id = c.id
order by o.name

can filter further by o.name