How to fetch column data by table names from VDB using Teiid java api.

nayan.bijagare Sep 2, 2019 2:02 PM

I need to fetch columns of any particular tables by table name. I couldn't find any method in java documentation.

Could you please suggest me any java method or any other solution to get column metadata?

1. Re: How to fetch column data by table names from VDB using Teiid java api.

rareddy Sep 2, 2019 2:15 PM (in response to nayan.bijagare)

Java JDBC API provides you with this on DatabaseMetadata class, see DatabaseMetaData (Java Platform SE 7 )

If you want to do this using SQL, then Teiid provides "SYS.Columns" table in system metadata. You can execute "select * from Sys.columns where TableName = 'foo'"
Actions