almask-mn
asked on
Reverse engineer and denerate DDLs from SQL Server 2008 objects
Are there any stored procedures or system views in SQL server 2008 that provide a way for you to generate DDL for SQL Server objects? sp_help or manually generating DDL from right clicking the tables is not just helping.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
i have written a SP that loops through all the objects and fire the sp_help_text and give all the DDLs at the end. please let me know if that helps.
ASKER
Thanks for your help.