• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 675
  • 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

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

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