get column field names of a table

SELECT * FROM INFORMATION_SCHEMA.Columns where TABLE_NAME = 'Foo' 
' where Foo is the table name you want details for.