I have looked through a lot of websites and that i haven't run into any code or tutorial that has went through more knowledge about getting the table names from one database.

Presuming I've 4 Databases and that i want what they are called of all of the tables inside the Database known as mp21, what's the code to do this?

I truly need assistance here. Any is appreciated.

use mp21
SELECT name FROM dbo.sysobjects WHERE xtype = 'U' 

In SQL SERVER, you can easily use -

select * from sys.tables

In MySQL this can list all databases:

show databases;

For all these that you can do:

use <database_name>;

after which

show tables;

if you're asking about .internet code you will want SMO :

using Microsoft.SqlServer.Management.Smo;
using Microsoft.SqlServer.Management.Common;

public static List<Table> GetTables(string connection, string databaseName)
            if (String.IsNullOrEmpty(connection))
                throw new ArgumentException("connection is null or empty.", "connection");

            Server srv = getServer(connection);
            return srv.Databases[databaseName].Tables.Cast<Table>().ToList();