How do I get the script to a database view

Question

I lost the script for a view that I created. Can I retrieve / recreate the script from the database using management studio?

Answer 1

You can also retrieve this information by querying the sys.sql_modules dynamic management view:

Here's an example:

USE AdventureWorks
GO
SELECT DEFINITION
  FROM sys.sql_modules  
 WHERE object_id = OBJECT_ID('HumanResources.vEmployee')