trafodion-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Liu, Ming (Ming)" <ming....@esgyn.cn>
Subject RE: command
Date Mon, 12 Sep 2016 09:48:45 GMT
Hi, Forling,

You can try to search in the system metadata, here is an example

select ROW_TOTAL_LENGTH , ROW_DATA_LENGTH from "_MD_".tables , "_MD_".objects where “_MD_”.objects.OBJECT_UID
= “_MD_”.tables.table_uid and objects.OBJECT_NAME='your_table_name’;

and you can check other columns in the “_MD_”.tables to see if there are other info you
need.

Others may have better approach, since I heard there are some new defined system dictionary
and views. Or maybe some new utility to grab these information. But above query is one method.

Thanks,
Ming

From: Dido_vansa [mailto:523766410@qq.com]
Sent: Monday, September 12, 2016 2:52 PM
To: user <user@trafodion.incubator.apache.org>; dev <dev@trafodion.incubator.apache.org>
Subject: command

Hi!

I have a problem about sql command in trafodion .
I want to obtain row length in a table , but I do not understand which command I can use in
this case.
I'm looking forward to your reply


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