I've tried various EOL characters in regular expressions but they don't appear to work, e.g.
\r\n\s
This for instance should select all CREATE TABLE statements.
(CREATE[ \s\w\n\r]*TABLE([ ,\(\)\.\w\s\n\r]*))
It works perfectly on Notepad++ even without \n\r
Why isn't it working?