To display list of tables in database

Submit a query on the SYS.TABLES table to get all of the data about the tables in a specific database.  Be sure to specify the database that you are targeting.

USE -- Specify your target database name (without the brackets)

GO

use
sp_help

It displays all the tables created in that database

To Display list of tables in the database:
SELECT * FROM INFROMATION_SCHEMA.TABLES WHERE TYPE='basetable'

To describe the structure of a particular table
SP_HELP table_name;