Is it worthwhile considering creating a synonym for this syntax that is more prevalent for equivalent functionality in other environments?
-----Original Message----- From: Pierre Smits [mailto:[email protected]] Sent: Thursday, April 7, 2016 8:38 PM To: [email protected] Subject: Re: In sqlci: how to show column names and associated data types? Thanks all, The command presented by Eric was the easiest/shortest solution. I had forgotten that one. Must be age/time of day. :-) Best regards, Pierre Smits ORRTIZ.COM <http://www.orrtiz.com> OFBiz based solutions & services OFBiz Extensions Marketplace http://oem.ofbizci.net/oci-2/ On Thu, Apr 7, 2016 at 9:15 PM, Anoop Sharma <[email protected]> wrote: > 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 >
