Sql Server - Get view creation statement for existing view

Question

Is there a way to get the statement that created a view for an existing view in SQL Server 2008? I thought there was a stored procedure or some metadata that had this data, but I'm not finding anything.

Answer 1

Right click on the view and script it.

Answer 2

Have you had a look at sp_helptext?

SQL SERVER – Stored Procedure to display code (text) of Stored Procedure, Trigger, View or Object

Answer 3

It's in sys.sql_modules. Other schema tables like INFORMATION_SCHEMA ones only contain the first 4000 characters of the definition (they truncate).

Answer 4

Check out this