The equivalent of describe [table] (MySQL) is exec sp_help [table]
describe [table]
exec sp_help [table]