I was required to generate a list of column names along with their data types in a table. For information about a table i used sp_help.
USE DBNameHere GO sp_help tableName GO
And for more to the point result with any filtration required i used following script
WHERE table_name = ‘TableNameHere’
This produced exact that i wanted.