To find the desc of an table in sql server 

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