SQLite / .NET: Get table names for attached database

Question

I can easily get the table names from a System.Data.SQLiteConnection like this:

 Public Function GetTableNames(ByVal uCn As SQLite.SQLiteConnection, ByVal uDBName As String) As List(Of String)

    Dim nTables As New List(Of String)
    Dim dt As DataTable = uCn.GetSchema("tables")
    For Each nRow As DataRow In dt.Rows
        Dim sTableName As String = nRow(2)
        nTables.Add(sTableName)
    Next

    Return nTables

End Function

However, I don't see how I can determine which database exactely I want to use. With the current approach, the table names are taken from the main database.

Does anybody know how I can say that want to get the table names from a specific database attached to the connection?

CL. · Accepted Answer · 2014-05-27 06:47:34Z

2

GetSchema does not support attached databases. You have read the table names directly from the system table:

SELECT name FROM MyOtherDB.sqlite_master WHERE type = 'table'

answered May 27, 2014 at 6:47

CL.

182k18 gold badges241 silver badges282 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

SQLite / .NET: Get table names for attached database

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related