T-SQL query to get number of tables, size in MBs & GBs for each database in an SQL Server

Does any one of a T-SQL query that i can execute against an SQL Server and get a list of all user database with their corresponding total number of tables, database size in MBs and database size in GBs for each database in an SQL Server instance.