GetViewDefinition

From SMTX Wiki
Jump to navigation Jump to search
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

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'