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.