see the SQL for a view

1. In Microsoft SQL Server Management Studio Express 2008, right click on a view in the "Object Explorer" and select: "Script View as"
2. then select: "ALTER To"
3. finally select: "New Query Editor Window"