generate ddl script via t-sql

• Kune

  SSC Enthusiast

  Points: 177

  More actions

  July 25, 2005 at 3:14 pm

  #94103

  Hi all,

  I am wondering if there is a way to generate ddl on object of database via t-sql ? For example, having a script with all the ddl statement of all objects for a user. I am trying to use sql server 2005.

  Regards,

  Tran

   

• July 28, 2005 at 8:00 am

  This was removed by the editor as SPAM

• venku009

  Mr or Mrs. 500

  Points: 503

  More actions

  July 29, 2005 at 5:17 am

  #578145

  Can you explain in detail with an example please. are you looking out to execute ddl statements dynamically?

• venku009

  Mr or Mrs. 500

  Points: 503

  More actions

  July 29, 2005 at 5:49 am

  #578148

  Here're some links for you - the first seems to have what you want!

  http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=9&messageid=183331#bm184520

  http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=19&messageid=181191#bm181614

• Kune

  SSC Enthusiast

  Points: 177

  More actions

  July 29, 2005 at 12:07 pm

  #578255

  Thanks venku009 for the information. I will try it.

  LqT