How to query table structure in SQL Server

Environment: SQL Server 2008 R2

Question: Query table Structure command

A friend familiar with MySQL and Oracle databases knows that you can query the structure of a table with DESC, but executing the DESC command in SQL Server will make an error.

Desc Student;  
There is a syntax error near the keyword ' desc '.

Now provides two command query table structure:

1.SP_HELP table_name;

Such as:

Sp_help Student;

The execution effect is as follows:

2.sp_columnstable_name;

Such as:

Sp_columns Student;

The execution effect is as follows:

The use of SP_HELP table_name is recommended because this command queries the table structure information in more detail.