Regular Expressions 101

CREATE TABLEthe literal text CREATE TABLE (case sensitive)

\s+a Unicode whitespace character, repeated at least once

\'the literal ' (39₁₀ / 47₈ / 27₁₆)

Group 1([^\']+)

Negated Character Class[^\']+

+matches at least one character outside the set below:

\'the literal ' (39₁₀ / 47₈ / 27₁₆)

Character Class[\s\S]+

+matches at least one character from the set below:

\sa Unicode whitespace character

\Sany character that is not Unicode whitespace

PRIMARY KEYthe literal text PRIMARY KEY (case sensitive)

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

Group 2([^,]+)

Negated Character Class[^,]+

+matches at least one character outside the set below:

,the literal , (44₁₀ / 54₈ / 2C₁₆)

Group 3([^\)]+)

Negated Character Class[^\)]+

+matches at least one character outside the set below:

\)the literal ) (41₁₀ / 51₈ / 29₁₆)

Detailed match information will be displayed here automatically.

25 tokens

Regular Expression

CREATE TABLE\s+\'([^\']+)[\s\S]+PRIMARY KEY\(([^,]+),([^\)]+)\)

New

CREATE TABLE 'dhcpr_dhcprelayinterface'  (
        'vrId' integer default 0,
        'ifName' string ,
        PRIMARY KEY(ifName,vrId),
        FOREIGN KEY (vrId) REFERENCES 'vr_vr'(vrId) ON DELETE CASCADE ON UPDATE CASCADE);