prefixing object name with scheme.

[ravilobo]

I need to prefix the objects with schema name. I have the following code,

Code: Select all

CREATE PROC F1
CREATE PROC DBO.F2

I need a RegEx which prefixes "dbo." to objects; at the same time it also takes care of existing schema.

Code: Select all

CREATE PROC DBO.F1
CREATE PROC DBO.F2

[ben_josephs]

Find what: CREATE PROC ([a-z0-9]+)$
Replace with: CREATE PROC DBO.\1

[X] Regular expression

Replace All

This assumes you are using Posix regular expression syntax:

Configure | Preferences | Editor

[X] Use POSIX regular expression syntax

[ravilobo]

Thank you Ben! It worked.

[ravilobo]

My apologies for not giving a proper example. The RegEx works for my earlier example, however it is not working for following case,

Code: Select all

CREATE PROC F1 AS SELECT GETDATE()
CREATE PROC DBO.F2 AS select col1 from tab

[ben_josephs]

Find what: CREATE PROC ([a-z0-9]+( |$))
Replace with: CREATE PROC DBO.\1

[ravilobo]

Amazing! Thank you ben!