trafodion-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Liu, Ming (Ming)" <>
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

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.


From: Dido_vansa []
Sent: Monday, September 12, 2016 2:52 PM
To: user <>; dev <>
Subject: command


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,
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message