how to get all information about table in sql server

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