CODEWITHSUNDEEP
c#sqlitedbconnectiongetschema
David Thielen
David Thielen

Reputation: 32926

Does Sqlite have a table, view, and/or column description in the metadata?

I am calling DbConnection.GetSchema("Tables") and that does not return a column named "table_comment".

Does Sqlite not have descriptions in its metadata?

Or if it has it, how do I query it?

thanks - dave

Upvotes: 1

Views: 712

Answers (1)

Kang
Kang

Reputation: 81

I'm not entirely sure this is what you're asking, but DbConnection.GetSchema("MetaDataCollections") will help you find all of the arguments that the GetSchema() method can take. These methods include views and columns. The "Tables" argument only returns a list of the tables. If by description you are referring to something similar to a MySQL DESCRIBE, you can query the sqlite_master to see the create statements. That's the closest I know of to comments (though there could certainly be ways I don't know of).

Upvotes: 1

Related Questions