get database objects information

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