How to retrieve all the Table Names in a SQL Database

Question

I want to retrieve all the table names in my database.

SELECT 
*
FROM sys.tables

I tried to use this but it didn't work The name of my database is called Information