Fantastic - worked like a charm - many thanks!
Upon deeper inspection, this actually isn't returning the correct information.
In ArcCatalog, I see something like this:
CREATE VIEW ViewName AS SELECT OBJECTID, ATT2 AS NewAtt2, ATT3 AS NewAtt3, LEFT(SOMELONGATTRIBUTE, 40) AS NewShortAtt FROM Database.User.OriginalTable
which is what I'm looking for - the SQL which created the original view.
In ArcGIS Pro, I see something like this:
SELECT OBJECTID, NEWATT2, NEWATT3, NEWSHORTATT from Database.User.ViewName
which isn't what I'm looking for.
Apologies for not examining more closely before marking your reply as correct.