alle Tabellennamen einer Datenbank abfragen

Beschreibung:

Mit dieser Methode werden alle Tabellennamen einer Access Datenbank abgerufen.

/// <summary>
/// Gets all tables.
/// </summary>
/// <param name="connectionString">The connection string.</param>
/// <returns></returns>
private static List<string> GetAllTables(string connectionString)
{
    List<string> tables = new List<string>();
    OleDbConnection connection = new OleDbConnection(connectionString);

    connection.Open();
    DataTable dataTable = connection.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, new object[] { null, null, null, null });

    for (int i = 0; i < dataTable.Rows.Count; i++)
        if (dataTable.Rows[i]["TABLE_TYPE"].ToString() == "TABLE")
            tables.Add(dataTable.Rows[i]["TABLE_NAME"].ToString());

    connection.Close();
    return tables;
}

Schlagwörter: Access, OleDB, Tabelle

Quelle: .NET-Snippets