Regular Expressions 101

Non-Capturing Group(?:CREATE TABLE.+[a-z]\s?\()

CREATE TABLEthe literal text CREATE TABLE (case sensitive)

.+any character (except for line terminators), repeated at least once

Character Class[a-z]

a-zone character from a (97₁₀) to z (122₁₀) (case sensitive)

\s?optionally matches any whitespace character

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

+repeats the group contents below at least once:

\n?optionally matches a line-feed (newline) character (ASCII 10)

\t?optionally matches a tab character (ASCII 9)

1st Alternative[a-z_]+\s(?:INTEGER|TEXT|BLOB|REAL|NULL).*

Character Class[a-z_]+

+matches at least one character from the set below:

a-zone character from a (97₁₀) to z (122₁₀) (case sensitive)

_the literal _ (95₁₀ / 137₈ / 5F₁₆)

\sany whitespace character

Non-Capturing Group(?:INTEGER|TEXT|BLOB|REAL|NULL)

1st AlternativeINTEGER

INTEGERthe literal text INTEGER (case sensitive)

2nd AlternativeTEXT

TEXTthe literal text TEXT (case sensitive)

3rd AlternativeBLOB

BLOBthe literal text BLOB (case sensitive)

4th AlternativeREAL

REALthe literal text REAL (case sensitive)

5th AlternativeNULL

NULLthe literal text NULL (case sensitive)

.*any character (except for line terminators), repeated any number of times

2nd Alternative\);$

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

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

$end of string, or before its final line terminator

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

Regular Expression

(?:CREATE TABLE.+[a-z]\s?\()(?:\n?\t?(?:[a-z_]+\s(?:INTEGER|TEXT|BLOB|REAL|NULL).*|\);$))+

New

CREATE TABLE asd (
	_id INTEGER PRIMARY KEY AUTOINCREMENT,
	name TEXT NOT NULL,
	breed TEXT NOT NULL,
	gender INTEGET NOT NULL DEFAULT 0,
	weight INTEGER NOT NULL DEFAULT 0
);


CREATE TABLE asd (
	_id INTEGER PRIMARY KEY AUTOINCREMENT,
	name TEXT NOT NULL,
	breed TEXT NOT NULL,
	gender INTEGER NOT NULL DEFAULT 0,
	weight INTEGER NOT NULL DEFAULT 0
);