sp_help is the best one in sql server to get the structure of table

In ORACLE it is SQL PLUS Command, displays structure of table. where as in SQL Server physical structure of table. at command prompt type the command SQL>DESC emp here no need to give semicolon in ORACLE. you get structure of the table.

This commansd is used for display  the structure of table.