SQLite3 program getting name of table

[bbranded]

Hello, Following the faq, I am attempting to query the a DB to obtain the list of table names with the following query: SELECT * FROM sqlite_master WHERE type='table' ORDER BY name I am using an ODBC driver and have written code in c#:

DbConnection.Open();

OdbcCommand DbCommand = DbConnection.CreateCommand();

DbCommand.CommandText = ("SELECT * FROM sqlite_master WHERE type='table' ORDER BY name");

DbReader = DbCommand.ExecuteReader();

List TableNames = new List();

for (int i = 0; i < DbReader.FieldCount; i++)
{
TableNames.Add(DbReader.GetName(i));
Trace.WriteLine(DbReader.GetName(i));
}

DbReader.Close();
DbConnection.Close();

I have a feeling that dbreader.getname(i) is returning the wrong thing, versus the query being incorrect. Can anyone help me figure out a way to identify the names of tables in an SQLite3 DB? Thanks, Matt

[loyal ginger]

The DbReader you obtained can be used to retrieve the table names from the "name" field: DbReader["name"] So your program should be modified to be like this:

DbConnection.Open();

OdbcCommand DbCommand = DbConnection.CreateCommand();

DbCommand.CommandText = ("SELECT * FROM sqlite_master WHERE type='table' ORDER BY name");

DbReader = DbCommand.ExecuteReader();

List TableNames = new List();

while(DbReader.Read()){
TableNames.Add(DbReader["name"]);
Trace.WriteLine(DbReader["name"]);
}

DbReader.Close();
DbConnection.Close();

Your original code was trying to retrieve all the fields in one record. Good luck!

[bbranded]

Thanks for the modified code! Can't make a list like that for some reason. Maybe I'm missing an import; I kept the casting. Because of this:

        OdbcCommand DbCommand = DbConnection.CreateCommand();
        
        //SQL query to return all table names
        //http://www.sqlite.org/faq.html#q7
        DbCommand.CommandText = ("SELECT name FROM sqlite\_master WHERE type='table' ORDER BY name");

        DbReader = DbCommand.ExecuteReader();
        

        List<string> TableNames = new List<string>();

        while (DbReader.Read())
        {
            TableNames.Add(DbReader\["name"\].ToString());
            Trace.WriteLine(DbReader\["name"\]);
        }


        DbReader.Close();

        if (TableNames.Contains("bandwidth\_records"))
        {
            //check to make sure column names are present
            DbConnection.Close(); 
        }
        else
        {
            //create table & columns
        )

Thanks!