Wednesday, October 17, 2012

Generating view definition in SQL Server

Make sure you have the privileges/access to the these commands.

1. sp_helptext [my_view_name]

2. Right click on the view in object explorer and generate a script

3. Run the query on information_schema.views table to see view definition

Hope this helps, i am also learning and Google is my friend :)

No comments:

Post a Comment