GetViewDefinition

Use the query below to see the view definition through an SQL command

 select definition
 from sys.objects     o
 join sys.sql_modules m on m.object_id = o.object_id
 where o.object_id = object_id( 'dbo.TicketHistory')
 and o.type      = 'V'