On Transact SQL language the sp_table_privileges is part of Catalog Stored Procedures and return a list of stored procedures in the current environment.
Sp_stored_procedures syntax:
sp_stored_procedures [ @sp_name = 'Procedure name.' ] ,
[ @sp_owner = 'The schema or database user who created.' ] ,
[ @sp_qualifier = 'Database name.' ] ;
Sp_stored_procedures example 1:
USE model;
GO
EXEC sp_stored_procedures ;
GO
Sp_stored_procedures example 2:
USE model;
GO
EXEC sp_stored_procedures
@sp_name = '%',
@sp_owner = 'dbo',
@sp_qualifier = 'model';
GO