In oracle we use the following the command to see description of an table.
desc tablename
In sql server we can use the following methods,
1. exec sp_columns TableName
(or)
2. exec sp_help TableName
(or)
3.
select *
from information_schema.columns
where table_name = ‘TableName’
order by ordinal_position