Regular Expression match (obtain) All table names, regular expression match

Regular Expression match (obtain) All table names, regular expression match
Document directory

• Write all the table names matching the SQL statement.

Return to the directory and write all the table names matching the SQL statement.

The regular expression is as follows:

\ * \ S + from \ s + [\ w \ [\] * \.? [\ W \ [\] * \.? \[? (\ B \ w +) \]? [\ R \ n \ s] *

Supports expressions

SELECT * FROM Config
SELECT * FROM [dbo]. IMEIUser
SELECT * FROM dbo. LotteryLog
SELECT * FROM [GreenPrize]
SELECT * FROM [dbo]. [Config]
SELECT * FROM dbo. [Prize]
SELECT * FROM [DBName]. [dbo]. [Config]

:

Use Match (input). Result ("$1") to obtain

Of course, the from in the regular expression can also be written as the greedy mode, which supports the acquisition of tables such as insert join update.