Oracle describe like functionality in MSSQL

If you are looking for Oracle's describe functionality in MSSQL, you can use following stored porc.

EXECUTE sp_help 'MyTable';
EXECUTE sp_columns 'MyTable'