title: How to list all the user tables in Sybase along with their row count?
body: <p>I would like to return all the tables and its count next to it. what is the quickest way to go about it?</p>
  
  <p>I know in Oracle, you can do something like below, but not sure about Sybase:</p>
  
  <pre><code>declare n number;
  begin
     for rec in (select object_name from user_objects where object_type='TABLE')
     loop
       execute immediate 'select count(*) from '||rec.object_name into n;
       dbms_output.put_line (rec.object_name||':'||n);
     end loop;
  end;
  </code></pre>