Re: Reverse engineer a phoneix table definition

2020-04-14 Thread Josh Elser
lebzadeh mailto:mich.talebza...@gmail.com>> > *Sent:* Sunday, 12 April 2020 1:36 AM > *To:* user mailto:user@phoenix.apache.org>> > *Subject:* Reverse engineer a phoneix table definition > Hi, > > I was wondering if an

Re: Reverse engineer a phoneix table definition

2020-04-14 Thread Sukumar Maddineni
offer is >> > >> > "SELECT * FROM SYSTEM.CATALOG where table_name = '" + tableName + "' >> > and table_schem = '" +schemaName + "'" >> > >> > S >> > -----------

Re: Reverse engineer a phoneix table definition

2020-04-14 Thread Geoffrey Jacoby
t; > "SELECT * FROM SYSTEM.CATALOG where table_name = '" + tableName + "' > > and table_schem = '" +schemaName + "'" > > > > S > > ------------ > > *From:* Mich

Re: Reverse engineer a phoneix table definition

2020-04-14 Thread Josh Elser
ame + "' and table_schem = '"  +schemaName + "'" S *From:* Mich Talebzadeh *Sent:* Sunday, 12 April 2020 1:36 AM *To:* user *Subject:* Reverse engineer a phoneix table definition Hi, I was wondering i

Re: Reverse engineer a phoneix table definition

2020-04-11 Thread Simon Mottram
Best I can offer is "SELECT * FROM SYSTEM.CATALOG where table_name = '" + tableName + "' and table_schem = '" +schemaName + "'" S From: Mich Talebzadeh Sent: Sunday, 12 April 2020 1:36 AM To: user Subject: R

Reverse engineer a phoneix table definition

2020-04-11 Thread Mich Talebzadeh
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 * h