Please help describe the scenario for this.
Omar Ishtiaq commented
SQL Server folks use this as an alternative to MySQL's 'SHOW CREATE TABLE'.
So having this or a suitable alternative would be great!
I want to be able to dump the DDL for objects (tables, views) and then apply them to other instances or compare them between instances.
Are there any alternatives?
sp_help has lot of parameters to filter out and it provides all tables information in a single query
Azure DBA commented
Unsure if sp_help covers or is equivalent to sp_helptext, but need to be able to issue a simple "SHOW" command to review the DDL of tables, views, and procedures.