to add to what has already been mentioned, one can also use traf metadata views to look at table/column details in a relational way.
select * from "_MD_".columns_view where schema_name = '<sch>' and table_name = '<tab>'; will show details of all columns in table <tab> invoke "_MD_".columns_view will show the columns that make up the view columns_view. anoop -----Original Message----- From: Qifan Chen [mailto:[email protected]] Sent: Thursday, April 7, 2016 12:04 PM To: dev <[email protected]> Subject: Re: In sqlci: how to show column names and associated data types? Any SQL actions from within sqlci can be logged via the log command. log <logfile> clear; -- start logging into <logfile>. Clear any content in <logfile> first. showddl <t>; log; --stop logging --Qifan On Thu, Apr 7, 2016 at 1:56 PM, Selva Govindarajan < [email protected]> wrote: > You can either issue > > invoke trafodion.<schema_name>.tablename or showddl > trafodion.<schema_name>.tablename > > Showddl output is such that it can be used to re-create the table when > needed. > > Selva > > On Thu, Apr 7, 2016 at 11:52 AM, Pierre Smits <[email protected]> > wrote: > > > Hi all, > > > > Maybe this is question answered in the documentation/pages already, > > but I might be overlooking it: how do I, in sqlci, get the > > information of a > table > > (meaning the column names, their data types and such) in a > > TRAFODION.SCHEMA? > > > > Best regards, > > > > Pierre Smits > > > > ORRTIZ.COM <http://www.orrtiz.com> > > OFBiz based solutions & services > > > > OFBiz Extensions Marketplace > > http://oem.ofbizci.net/oci-2/ > > > > > > -- > - cheers > selvag > -- Regards, --Qifan
