How to Obtain the SQL Select statement from a View

• doug.milostic

  Ten Centuries

  Points: 1270

  More actions

  January 13, 2011 at 6:22 pm

  #232950

  Hi Guys

  I have a View defined in my database.

  In a Stored Procedure I need to retrieve the SQL Select statement from the View and store it in a variable.

  Is this possible?

  Sound easy, but cant find anything out there.

  Any help is appreciated.

  Please, lets not get into a long discussion as to why I need to do this, I just do.

  Cheers

  Doug

• doug.milostic

  Ten Centuries

  Points: 1270

  More actions

  January 13, 2011 at 8:51 pm

  #1273405

  Found it. I used the following.

  Set @sql = (SELECT m.definition FROM sys.sql_modules m, sys.views v WHERE m.object_id = v.object_id AND v.name = 'view_name')

  Tks