C#

SHOW [FULL] TABLES [{FROM | IN} db_name]
    [LIKE 'pattern' | WHERE expr]

SELECT Table_Name FROM Information_Schema.Tables WHERE Table_Type = 'BASE TABLE' AND Table_Schema = 'yourSchema'

public override List<string> GetTableNames() {
	using (OleDbConnection con=new OleDbConnection(connectionString)) {
		con.Open();
		DataTable dt=con.GetSchema("Tables");
		List<string> tableNames=new List<string>();
		foreach (DataRow row in dt.Rows) {
			string tableName=(string)row["TABLE_NAME"];
			tableNames.Add(tableName);
		}
		return tableNames;
	}
}

Luc Pattyn wrote:

They invented "documentation"