CREATEthe literal text CREATE (case sensitive) +the literal (3210 / 408 / 2016) , repeated at least once
?repeats the group contents below at most once:
TEMPORARYthe literal text TEMPORARY (case sensitive) +the literal (3210 / 408 / 2016) , repeated at least once
TABLEthe literal text TABLE (case sensitive) *the literal (3210 / 408 / 2016) , repeated any number of times
?repeats the group contents below at most once:
.*?any character (except for line terminators), repeated any number of times
\.the literal . (4610 / 568 / 2E16)
Group table(?P<table>.*?) .*?any character (except for line terminators), repeated any number of times
\(the literal ( (4010 / 508 / 2816)
.*?any character (except for line terminators), repeated any number of times
\)the literal ) (4110 / 518 / 2916)
.*?any character (except for line terminators), repeated any number of times
USINGthe literal text USING (case sensitive) +the literal (3210 / 408 / 2016) , repeated at least once
Negated Character Class[^\s]+ +matches at least one character outside the set below:
\sany whitespace character
Group 6( +OPTIONS *\([^)]+\))? ?repeats the group contents below at most once:
+the literal (3210 / 408 / 2016) , repeated at least once
OPTIONSthe literal text OPTIONS (case sensitive) *the literal (3210 / 408 / 2016) , repeated any number of times
\(the literal ( (4010 / 508 / 2816)
Negated Character Class[^)]+ +matches at least one character outside the set below:
)the literal ) (4110 / 518 / 2916)
\)the literal ) (4110 / 518 / 2916)
Group 7( *PARTITIONED BY \((?P<pcol>.*?)\))? ?repeats the group contents below at most once:
*the literal (3210 / 408 / 2016) , repeated any number of times
PARTITIONED BY the literal text PARTITIONED BY (case sensitive) \(the literal ( (4010 / 508 / 2816)
.*?any character (except for line terminators), repeated any number of times
\)the literal ) (4110 / 518 / 2916)
g modifier: global. Finds all matches instead of stopping after the first