Please enable JavaScript to use regex101
/
^
r
e
g
e
x
[
\
-
_
]
?
1
0
1
$
/
i
Reg
ular
Ex
pressions
101
Upgrade to Pro
Enterprise
Community Library
How to contribute
x
Match T-SQL view definition
Open Workspace
PCRE2 (PHP)
Match
Created 2023-11-01 10:41
1
Regular Expression
/
USE
\s
(?P<db>
\[
\w
+
\]
)
;
?
\s
*
CREATE
VIEW
(?P<schema>
\[
\w
+
\]
)
\.
(?P<name>
\[
\w
+
\]
)
AS
\s
*
(?P<sql>
.
+
)
/
gis
Description
This regex matches the Transact SQL statement for selecting the database and creating a view.
Submitted by
Anonymous