Please enable JavaScript to use regex101
/
^
r
e
g
e
x
[
\
-
_
]
?
1
0
1
$
/
i
Reg
ular
Ex
pressions
101
Upgrade to Pro
Enterprise
Regular Expression
/
^[ \t]*create[ \t]+(view|procedure|proc)+[ \t]+(.+)$\n((^(?![ \t]*go[ \t]*).*$\n)+)^[ \t]*go[ \t]*$
/
gmi
Input 1
New
set quoted_identifier on set ansi_nulls on go -------------------------------------------------------------------------------- -- NAME: AP_INVOICE -- -- PURPOSE: Represents the one to one relationship between Fin_APINVMST and -- Fin_SUBINV. No filtering done, this view includes all rows. -------------------------------------------------------------------------------- if objectproperty(object_id('AP_INVOICE'), 'IsView') = 1 drop view AP_INVOICE go create view AP_INVOICE as select a.APIMIVNM ,a.APIMVNID ,a.APIMDATE ,a.APIMTYPE ,a.APIMDOCN ,a.APIMICDT ,a.APIMUTAX ,a.APIMVOCH ,a.APIMLCRD ,a._Row
Extraction
set quoted_identifier on set ansi_nulls on go -------------------------------------------------------------------------------- -- NAME: AP_INVOICE -- -- PURPOSE: Represents the one to one relationship between Fin_APINVMST and -- Fin_SUBINV. No filtering done, this view includes all rows. -------------------------------------------------------------------------------- if objectproperty(object_id('AP_INVOICE'), 'IsView') = 1 drop view AP_INVOICE go create view AP_INVOICE as select a.APIMIVNM ,a.APIMVNID ,a.APIMDATE ,a.APIMTYPE ,a.APIMDOCN ,a.APIMICDT ,a.APIMUTAX ,a.APIMVOCH ,a.APIMLCRD ,a._Row