Currently I was searching describe like function, which used in Oracle PLSQL to get the detail of table. I found equvilent function in TSQL “sp_help”.
you can used it as
sp_help <table_name>
i.e
sp_help studentdet
A practitioner’s musings on Dynamics 365 Finance and Operations