Regex Editor & Tester

Matches T-SQL CREATE or ALTER statements declaring functions or procedures, including optional schema-qualified object names wrapped in SQL Server identifier delimiters such as [brackets] or "quotes" (e.g., ALTER PROCEDURE [dbo].[MyProc]). Useful for scanning SQL scripts to find, extract, or inventory stored procedures and user-defined functions in SQL Server databases.