Is possible to retrieve the original SQL that I used to create a view ? I need the original SQL exactly as I wrote, because the following sentence add a lot of schemas and quotation marks ( not incuded obviusly in my original SQL ) that makes it absolutely confused to read and modify in complex querys.
SELECT VIEW_DEFINITION FROM INFORMATION_SCHEMA.VIEWS
WHERE TABLE_NAME = ‘yourviewname’
Thanks in advance,