CREATE PROCEDURE [dbo].[sp_find_procs_containing]@search VARCHAR(100) = ” AS SET @search = ‘%’ + @search + ‘%’ SELECT ROUTINE_NAME, ROUTINE_DEFINITION FROM INFORMATION_SCHEMA.ROUTINES WHERE ROUTINE_DEFINITION LIKE @search ORDER BY ROUTINE_NAME
CREATE PROCEDURE [dbo].[sp_find_procs_containing]@search VARCHAR(100) = ” AS SET @search = ‘%’ + @search + ‘%’ SELECT ROUTINE_NAME, ROUTINE_DEFINITION FROM INFORMATION_SCHEMA.ROUTINES WHERE ROUTINE_DEFINITION LIKE @search ORDER BY ROUTINE_NAME
Goed script.
Ook leuk voor als je denkt: In welke tabel hangt deze kolom ook al weer uit?
ALTER PROCEDURE [dbo].[sp_find_table_containing_column_name]@search VARCHAR(100) AS
BEGIN
SET @search = ‘%’ @search ‘%’
SELECT *
FROM INFORMATION_SCHEMA.COLUMNS WHERE COLUMN_NAME like @search
END
Das ook een handig script. Bedankt voor de tip!