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.  
Who is Participating?
chapmandewConnect With a Mentor Commented:
Yeah, so that is one of the main pains for me...that SSMS doesn't provide OBJECT_DEFINITION functionality for tables.  

I wrote an article on how you can script this out...hope it helps.
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.
almask-mnAuthor Commented:
Thanks for your help.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.