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:523766...@qq.com]
Sent: Monday, September 12, 2016 2:52 PM
To: user <user@trafodion.incubator.apache.org>; dev 
<d...@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

Reply via email to