patternsqlMinor

Is there a way to see the code that creates a view in SQL server management studio?

Submitted by: @import:stackexchange-dba·Mar 10, 2026·

Viewed 0 times

thecreatesserversqlwayviewseemanagementthatstudio

Problem

I want to see the underlying code for how a view is created in SQL server management studio. Is there a way to do this?

I want to see any date filters, etc, applied to this view in hard code.

Solution

select text from sys.syscomments where id = object_id ('dbo.myview')

select definition from sys.all_sql_modules where object_id = object_id ('dbo.myview')

select definition from sys.sql_modules where object_id = object_id ('dbo.myview')

select object_definition (object_id ('dbo.myview')) object_definition

sp_helptext 'dbo.myview'

Code Snippets

select text from sys.syscomments where id = object_id ('dbo.myview')

select definition from sys.all_sql_modules where object_id = object_id ('dbo.myview')

select definition from sys.sql_modules where object_id = object_id ('dbo.myview')

select object_definition (object_id ('dbo.myview')) object_definition

sp_helptext 'dbo.myview'

Context

StackExchange Database Administrators Q#157217, answer score: 5

Revisions (0)

No revisions yet.