Thank you for your input, I appreciate your help!

 

Kevin

 

From: Cody Marcel [mailto:cmarcel@salesforce.com]
Sent: Tuesday, July 14, 2015 9:18 AM
To: user@phoenix.apache.org
Subject: Re: Query DDL from Phoenix

 

This should do it.

 

DatabaseMetaData dbmd = connection.getMetaData();
ResultSet resultSet = dbmd.getColumns(
null, schemaName, tableName, null);

 

On Mon, Jul 13, 2015 at 8:51 PM, Eli Levine <elilevine@gmail.com> wrote:

The standard JDBC way is to use Connection.getMetadata(). See if that does what you need. You can also query SYSTEM.TABLE directly via Phoenix if you know what you are doing. 


On Jul 13, 2015, at 4:57 PM, Kevin Verhoeven <Kevin.Verhoeven@ds-iq.com> wrote:

Is there a way to query the table structure of user tables from Phoenix? For example, to retrieve the CREATE TABLE syntax?  

 

Thank you,

 

Kevin Verhoeven