Answer the question
In order to leave comments, you need to log in
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
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question