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
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