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 <gjac...@salesforce.com> wrote: > 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 8:01 AM Josh Elser <els...@apache.org> wrote: > >> 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 = '" +schemaName + "'" >> > >> > S >> > ------------------------------------------------------------------------ >> > *From:* Mich Talebzadeh <mich.talebza...@gmail.com> >> > *Sent:* Sunday, 12 April 2020 1:36 AM >> > *To:* user <user@phoenix.apache.org> >> > *Subject:* Reverse engineer a phoneix table definition >> > Hi, >> > >> > I was wondering if anyone has a handy script to reverse engineer an >> > existing table schema. >> > >> > I guess one can get the info from system.catalog table to start with. >> > However, I was wondering if there is a shell script already or I have >> to >> > write my own. >> > >> > Thanks, >> > >> > Dr Mich Talebzadeh >> > >> > LinkedIn >> > / >> https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw/ >> > >> > http://talebzadehmich.wordpress.com >> > >> > >> > *Disclaimer:* Use it at your own risk.Any and all responsibility for >> any >> > loss, damage or destruction of data or any other property which may >> > arise from relying on this email's technical content is explicitly >> > disclaimed. The author will in no case be liable for any monetary >> > damages arising from such loss, damage or destruction. >> > >> > -- <https://smart.salesforce.com/sig/smaddineni//us_mb/default/link.html>
