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: Reverse engineer a phoneix table definition Hi, I w

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