The package contains two T_SQL procedures: sp_desc and sp_desc_more.
Both of them are like the DESC[RIBE] command in SQL*Plus.
These can be useful for those who are accustomed to DESC[RIBE] command in SQL*Plus.
The two variants, sp_desc and sp_desc_more, are suitable to describe TABLES and VIEWS.
Outputs are similar to the output of the SQL*Plus DESC command, there are just some differences:
both of them show the auto-increment (IDENTITY) primary keys, moreover sp_desc_more shows object
comments and all references, too. (See sreenshots.)
Follow DESC[RIBE] for MSSQL
Other Useful Business Software
AI-powered service management for IT and enterprise teams
Give your IT, operations, and business teams the ability to deliver exceptional services—without the complexity. Maximize operational efficiency with refreshingly simple, AI-powered Freshservice.
Rate This Project
Login To Rate This Project
User Reviews
Be the first to post a review of DESC[RIBE] for MSSQL!