Cool,
Thanks Anoop,
eric
From: Anoop Sharma [mailto:anoop.sha...@esgyn.com]
Sent: Thursday, March 2, 2017 9:18 AM
To: user@trafodion.incubator.apache.org; Kevin
Cc: d...@trafodion.incubator.apache.org
Subject: RE: trafodion jdbc metadata related question
One can also use metadata views to get in
One can also use metadata views to get information about columns, keys etc
for a particular table.
Metadata views are defined in TRAFODION."_MD_" schema.
>>get views in schema "_MD_";
Views in Schema TRAFODION._MD_
==
COLUMNS_VIEW
INDEXES_VIEW
KEYS_VIEW
REF_CONSTRAIN
Thanks Kevin,
That helps
regards
Eric
Sent from my Samsung Galaxy smartphone.
Original message
From: "Xu, Kai-Hua (Kevin)"
Date: 3/2/17 3:59 AM (GMT-06:00)
To: Eric Owhadi
Cc: user@trafodion.incubator.apache.org, d...@trafodion.incubator.apache.org
Subject: RE: trafodion jd
Hi Eric,
As you see, it's true that some columns are hidden. Another way is to retrieve
metadata table directly as follows:
--retrieve all columns
select c.* from "_MD_".objects o left join "_MD_".columns c on
o.object_uid=c.object_uid where o.schema_name='ERIC' and o.object_name='TBL';
--retrie
