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.)
Project Samples
Follow DESC[RIBE] for MSSQL
Other Useful Business Software
Ship Agents Faster
Gemini Enterprise Agent Platform lets you rapidly build, scale, govern and optimize production-ready agents grounded in your organization's data. The platform enables developers to build custom or pre-built agents for virtually any use case. New customers get $300 in free credits.
Rate This Project
Login To Rate This Project
User Reviews
Be the first to post a review of DESC[RIBE] for MSSQL!
