Add new column to existing table

ALTER TABLE tbl1 ADD name varchar NOT NULL

Find any keywords in Stored procedure

SELECT Routine_Name, Routine_Definition
FROM Information_Schema.Routines
WHERE Routine_Definition Like '%tblname%'
AND Routine_Type = 'Procedure'