Return the names from columns in sqlite database [

Question

This question already has an answer here:

Returning column names from table in SQLite using Java GUI (1 answer)

Closed 3 years ago.

I am trying to perform an sqlite query in java code which will return the columns names from an sqlite table. How can I do so? I am only managed to get the values from the table and not the names of the columns.

Answer 1

Use "select ... limit 0" query to get just metadata, then use ResultSetMetaData objects to actually retrieve it. Something like this:

List<String> sqliteTableColumns(Connection connection, String tableName) {
    List<String> columns = new ArrayList<>();
    String sql = "select * from " + tableName + " LIMIT 0";
    Statement statement = connection.createStatement();
    ResultSet rs = statement.executeQuery(sql);
    ResultSetMetaData mrs = rs.getMetaData();
    for(int i = 1; i <= mrs.getColumnCount(); i++) {
        columns.add(mrs.getColumnLabel(i));
    }
    return columns;
}