static void GetSchema()
{
    static string csvConnectionString = $"Uri='sampleCSV.csv'";       

    Console.WriteLine("Query all Accounts...");
            
    using (var con = new C1CSVConnection(csvConnectionString))
    {
        con.Open();

        //Get list a of tables
        DataTable databaseTables = con.GetSchema("Tables");
        Console.WriteLine("List of Tables in database:");
        foreach (DataRow row in databaseTables.Rows)
        {
            //Display Tablename
            Console.WriteLine(row["TableName"]);
        }
        //Get column names in a table
        DataTable datatableColumns = con.GetSchema("Columns", new string[] { "sampleCSV" });
        Console.WriteLine("\n Books Table columns:");
        foreach (DataRow column in datatableColumns.Rows)
        {
            //Display column properties                  
            Console.Write(column["ColumnName"]);
            Console.Write("\t" + column["DataType"]);
        }
    }
}
        
static void ShowDataTable(DataTable table, int length = 25)
{
    foreach (DataColumn col in table.Columns)
    {
        Console.Write("{0,-" + length + "}", col.ColumnName);
    }
    Console.WriteLine();

    foreach (DataRow row in table.Rows)
    {
        foreach (DataColumn col in table.Columns)
        {
            if (col.DataType.Equals(typeof(DateTime)))
                Console.Write("{0,-" + length + ":d}", row[col]);
            else if (col.DataType.Equals(typeof(decimal)))
                Console.Write("{0,-" + length + ":C}", row[col]);
            else
                Console.Write("{0,-" + length + "}", row[col]);
        }
        Console.WriteLine();
    }
}