Re: Reverse engineer a phoneix table definition

2020-04-14 Thread Josh Elser
That should be there already, but that doesn't help the existing 4.x release lines (which, I assume, would be what Mich cares about). On 4/14/20 11:59 AM, Sukumar Maddineni wrote: How about a simple idea of redirecting all DDL statements to SYSTEM.LOG by default which will be useful for

Re: Reverse engineer a phoneix table definition

2020-04-14 Thread Sukumar Maddineni
How about a simple idea of redirecting all DDL statements to SYSTEM.LOG by default which will be useful for logging+auditing purposes and also for recreating table if needed. -- Sukumar On Tue, Apr 14, 2020 at 8:49 AM Geoffrey Jacoby wrote: > This is a frequent feature request we unfortunately

Re: Reverse engineer a phoneix table definition

2020-04-14 Thread Geoffrey Jacoby
This is a frequent feature request we unfortunately haven't implemented yet -- see PHOENIX-4286 and PHOENIX-5054, one of which I filed and the other one Josh did. :-) I agree with Josh, I'd love to see an implementation of this if someone has bandwidth. Geoffrey Jacoby On Tue, Apr 14, 2020 at

Re: Reverse engineer a phoneix table definition

2020-04-14 Thread Josh Elser
Yeah, I don't have anything handy. I'll happily review and commit such a utility if you happen to write one (even if flawed). On 4/12/20 1:31 AM, Simon Mottram wrote: Best I can offer is  "SELECT * FROM SYSTEM.CATALOG where table_name = '" + tableName + "' and table_schem = '"