I have the following beginning of function sql that I will use for a procedures / function recreation system in C #
Create Function dbo.JN_FN_DataAtual(@TESTE INT)
And I created the regular expression
(?si)\bCREATE\s*\bFUNCTION?\s*(?<owner>\w*.\b)(?<function>.*?\W)
But you have returned the following results:
1- dbo.
2- JN_FN_DataAtual (
It worked, but the ". nor the parentheses "(".
What can it be?