Thank you for your input, I appreciate your help!




From: Cody Marcel []
Sent: Tuesday, July 14, 2015 9:18 AM
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 <> 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 <> 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