1

Can any one help me finding the information of multiple tables in SYBASE. I Know in ORACLE we do Select * from USEr_segments;

SUNITH
  • 15
  • 10

1 Answers1

0

Something similar would be visible through running

select * from sysobjects where uid = user_id() and type = 'U'
Adam Leszczyński
  • 1,079
  • 7
  • 13
  • It is showing nothing...I am looking for something like this "call sp_iqtablesize ('dba.emp1')" but I need multiple table results at a single command – SUNITH May 17 '18 at 18:03
  • Please correct your question and write exactly what you want to have. You did not write explicitly what you wanted. I have written the answer for Sybase ASE. – Adam Leszczyński May 17 '18 at 19:28
  • I am agreeing with your answer but in that query I can not see the size of each table. I am more concerning about the size in that information. Please help me out to finding the size of multiple tables at a single result – SUNITH May 17 '18 at 19:40
  • So far, I am using this query "call sp_iqtablesize ('dbo.valid0000')" which can only show single table result. – SUNITH May 17 '18 at 19:43