How to Find & Sort Table Size in SAP IQ

In SAP IQ database, you can use below command to find and sort table size using the interactive SQL.

select Owner,Object_Name, convert (float,substr (columns,1, char_length (columns)-1))*power (1024,charindex(substr(columns,char_length(columns),1),'BKMGTP')-1) as Bytes from sp_iqdbspaceinfo() order by 3 desc

The output will list from the top size table to the lowest size table,

If you are using below command, you will only able to list to only one specific table.

sp_iqtablesize ( table_owner.table_name )
 
##Example##
 
sp_iqtablesize ('ITSITI.ARADAEM')