• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 680
  • Last Modified:

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.  
0
almask-mn
Asked:
almask-mn
1 Solution
 
chapmandewCommented:
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.

http://blogs.techrepublic.com.com/datacenter/?p=431
0
 
vasureddymCommented:
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.
0
 
almask-mnAuthor Commented:
Thanks for your help.
0
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.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now