Describe table structure in MS SQL Server

I liked the describe MyTable in MySQL and missed it on SQL Server when I started to work with it. Turns out, there is a way to do the same there as well:

exec sp_columns MyTable

This is not exactly the same as describe MyTable but it serves similar purpose.

Advertisements