P
P
Pavel2017-09-05 10:03:18
SQL
Pavel, 2017-09-05 10:03:18

How to see the full contents of a view in INFORMATION_SCHEMA?

The VIEW_DEFINITION column in the INFORMATION_SCHEMA.views table contains the text of the view. But when I select a cell with text and hit copy, it only copies part of the view (the view is very large). How can I pull out the entire text of the view?
Through ALTER VIEW and CREATE VIEW in the context menu, this is understandable, but you need to pull it out through the script (I want to find all views with certain content)

Answer the question

In order to leave comments, you need to log in

1 answer(s)
D
d-stream, 2017-09-05
@rusbaron

RightClick -> SaveAs - manually
or put into a variable of the corresponding type (nvarchar(max))

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question