How do I get to know each column details of a table

How to I get each column details of a table with out opening table in design
mode.> How to I get each column details of a table with out opening table in
> design
> mode.
http://www.aspfaq.com/2177|||Soumya,
In EM, right-click over the table and select "properties". In QA, use stored
procedure sp_help or query the view "information_schema.columns".
Example:
use northwind
go
exec sp_help orders
go
select *
from information_schema.columns
where table_name = 'orders'
order by ordinal_position
go
AMB
"Soumya" wrote:

> How to I get each column details of a table with out opening table in desi
gn
> mode.sql