trafodion-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Selva Govindarajan <selva.govindara...@esgyn.com>
Subject Re: In sqlci: how to show column names and associated data types?
Date Thu, 07 Apr 2016 18:56:34 GMT
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 <pierre.smits@gmail.com>
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

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message