Have you looked at SQL::Statement? It can parse many types of SQL statements and then return information about these statements. You sound as if you don't have any control over the format that your CREATE statement is sent to you, so parsing with regular expressions without prior knowledge of the formatting will be guesswork. If SQL::Statement works for you, use it instead.