Regular Expressions 101

^start of line

Group 1(CREATE\sTABLE(?s).*FOREIGN KEY\s\((?s).*ENABLE)

CREATEthe literal text CREATE (case sensitive)

\sany whitespace character

TABLEthe literal text TABLE (case sensitive)

(?s)applies the following effective flags to the remainder of the pattern: gms

s modifier: single line. Allows a dot to match line terminators

.*any character, repeated any number of times

FOREIGN KEYthe literal text FOREIGN KEY (case sensitive)

\sany whitespace character

\(the literal ( (40₁₀ / 50₈ / 28₁₆)

(?s)applies the following effective flags to the remainder of the pattern: gms

s modifier: single line. Allows a dot to match line terminators

.*any character, repeated any number of times

ENABLEthe literal text ENABLE (case sensitive)

Global pattern flags

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

No unit tests · Add a test to get started

25 tokens

Regular Expression

^(CREATE\sTABLE(?s).*FOREIGN KEY\s\((?s).*ENABLE)

There are no unit tests, click to add some.