what is local temporary table in sql code example

Example: how to search table name in stored procedure in sql server

SELECT Name
FROM sys.procedures
WHERE OBJECT_DEFINITION(OBJECT_ID) LIKE '%TableNameOrWhatever%'