What is the equivalent of 'describe table' in MSSQL?

You can use the sp_columns stored procedure:

exec sp_columns MyTable