How to het the table information in SQL

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