Regular Expressions 101

Explanation

Pro

Group 1(CREATE\s+TABLE\s+(\w+)\s*;\s*ALTER\s+TABLE\s+\2\s*;)

CREATEthe literal text CREATE (case sensitive)

\s+any whitespace character, repeated at least once

TABLEthe literal text TABLE (case sensitive)

\s+any whitespace character, repeated at least once

Group 2(\w+)

\w+any word character, repeated at least once

\s*any whitespace character, repeated any number of times

;the literal ; (59₁₀ / 73₈ / 3B₁₆)

\s*any whitespace character, repeated any number of times

ALTERthe literal text ALTER (case sensitive)

\s+any whitespace character, repeated at least once

TABLEthe literal text TABLE (case sensitive)

\s+any whitespace character, repeated at least once

\2the text saved by group 2

\s*any whitespace character, repeated any number of times

;the literal ; (59₁₀ / 73₈ / 3B₁₆)

Global pattern flags

g modifier: global. Finds all matches instead of stopping after the first

Detailed match information will be displayed here automatically.

25 tokens

(CREATE\s+TABLE\s+(\w+)\s*;\s*ALTER\s+TABLE\s+\2\s*;)

CREATE TABLE ABC;
ALTER TABLE ABC;

CREATE TABLE ABC;
ALTER TABLE ABC;