get database object information in sql

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