Test, validate and match regular expressions
This regular expression matches SQL CREATE TABLE statements from a database dump file. It looks for the phrase "CREATE TABLE" at the beginning of a line, captures everything up to the first semicolon, and includes the semicolon. This is useful for database migrations, schema analysis, or extracting table definitions from SQL scripts.