How to get column names of a table using spring data jpa

Question

I am using spring boot, spring data JPA, I am searching for solution to get all column names of a given table. But could not found as per my requirements

Not want a solution with native query.Looking for general solution using spring data abstraction.

I am able to get the column names using normal java but i want to fetch them using spring data JPA.

Possible Duplicate of https://stackoverflow.com/questions/31239812/is-there-any-simplest-way-to-get-table-metadata-column-name-list-information — Romil Patel, Mar 05 '19 at 09:32
Possible duplicate of [Is there any Simplest way to get Table metadata (column name list) information, in Spring Data JPA ? which could I use on universal database](https://stackoverflow.com/questions/31239812/is-there-any-simplest-way-to-get-table-metadata-column-name-list-information) — xerx593, Mar 05 '19 at 12:01

abhinavsinghvirsen · Answer 1 · 2019-03-05T09:49:30.033

3

they are several ways

public interface TableMetadataRepository extends JpaRepository<TableMetadata, TableMetadataKey>
{
  TableMetadata findByTableName(String tableName);
}

then you can go for

List<TableMetadata> metadata = tableMetadataRepository.findAll()
TableMetadata metadataofspecifictable = tableMetadataRepository.findByTableName("urtable");

edited Mar 05 '19 at 09:49

answered Mar 05 '19 at 09:32

abhinavsinghvirsen

1,853
16
25

thanks for your reply, do I need to create TableMetadata class? – Akki Mar 05 '19 at 09:44
yes you need to create TableMetadata class to hold metadata information – abhinavsinghvirsen Mar 05 '19 at 09:48

How to get column names of a table using spring data jpa

1 Answers1