CREATE TABLE the literal text CREATE TABLE (case sensitive) \x60the literal ` (6016 / 1408 / 9610)
\w*any word character, repeated any number of times
\x60the literal ` (6016 / 1408 / 9610)
the literal (3210 / 408 / 2016)
\(the literal ( (4010 / 508 / 2816)
\na line-feed (newline) character (ASCII 10)
.*?any character, repeated any number of times
^start of line
\)the literal ) (4110 / 518 / 2916)
the literal (3210 / 408 / 2016)
.*?any character, repeated any number of times
;the literal ; (5910 / 738 / 3B16)
g modifier: global. Finds all matches instead of stopping after the first
m modifier: multiline. Causes ^ and $ to match the start and end of each line, not only the start and end of the string
s modifier: single line. Allows a dot to match line terminators