Accessing the Code Of A View

• twosober

  Valued Member

  Points: 53

  More actions

  March 22, 2002 at 5:13 am

  #158351

  Is there an easy way (besides copying and pasting) for me to get the actual code from a View stored on my SQL box to an ASP page so that it can be modified and then re-created.

  Thanks In Advance

• Andy Warren

  SSC Guru

  Points: 119902

  More actions

  March 22, 2002 at 5:49 am

  #425910

  You can retrieve it from sysobjects or use DMO to get it. Why would you want to alter a view in a web page?

  Andy

  Andy
  SQLAndy - My Blog!
  Connect with me on LinkedIn
  Follow me on Twitter

• Antares686

  SSC Guru

  Points: 125444

  More actions

  March 22, 2002 at 8:28 am

  #425919

  You can also use sp_helptext 'viewname' to get it as a recordset.

  "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)