How to describe table in SQL Server 2008?

You can use sp_columns, a system stored procedure for describing a table.

exec sp_columns TableName

You can also use sp_help.