How to get the information of stored procedure in SQL

SQL Sp_help is part of database engine stored procedures ,which returns information about a database object or a data type.