Myregextester.com is the premier online regular expressions tester that allows visitors to construct, test, and optimize regular expressions.

 Click here to manually set the number of rows for match/replacement textareas. Regex Cheat Sheet Regex Tutorials Regex Book
URL SOURCE:   FILE SOURCE:

MATCH PATTERN:

REPLACEMENT PATTERN:

OPERATION: # # USE .NET FLAGS: i
x		 m
s		  Help SHOW MATCH ARRAY:    EXPLAIN:  OPTIMIZE:    SHOW CODE: PHP
ASP		 VB.NET
C#.NET		 Java
JS
DELIM: HIGHLIGHT MATCHES:      GEN SAMPLES:   
    Save example     Help     FROM: TO: 

PASSWORD RESTRICTIONS:

Allow only these characters:  (any character) [  ]
At Least  Total Characters
No More Than   Total Characters
At Least  Lowercase Characters (a-z)
At Least  Uppercase Characters (A-Z)
At Least  Numeric Characters (0-9)
At Least  Special Characters in [^a-zA-Z0-9] [  ]
Disallow sequential alphanumeric sequences of or more (i.e. 123... abc... ABC...)
Disallow repeating characters of or more (i.e. 11... aa... AA... %%...)

WORD LIST:



SOURCE TEXT:

HIGHLIGHTED MATCHES:

Select All (to copy etc.)
CAPTURE GROUPS Help
0

n a .sql script file I would like to remove ALTER TABLE blah.foo DISABLE CHANGE_TRACKING

How to achieve using regex replace? Please assist. 
n a .sql script file I would like to remove ALTER TABLE blah.rhubarb_plant DISABLE CHANGE_TRACKING

How to achieve using regex replace? Please assist. 
n a .sql script file I would like to remove ALTER TABLE my_dbo.my_table_name DISABLE CHANGE_TRACKING

How to achieve using regex replace? Please assist.

RESULTS:

Select All (to copy etc.)
Execution Time(sec.):
0.000009

Raw Match Pattern:
ALTER TABLE \w+\.\w+ DISABLE CHANGE_TRACKING

Raw Replace Pattern:


$sourcestring after replacement:
n a .sql script file I would like to remove

How to achieve using regex replace? Please assist.
n a .sql script file I would like to remove

How to achieve using regex replace? Please assist.
n a .sql script file I would like to remove

How to achieve using regex replace? Please assist.