Warning! It depends on the statistics and could be not accurate!
Sybase
select user_name( obj.uid), obj.name , rowcnt(doampg)
from sysindexes idx, sysobjects obj
where idx.indid < 2 and idx.id = obj.id and obj.type = 'U'
order by 1,2
go
select object_name( idx.id ), rowcnt(doampg)
from sysindexes idx
where idx.indid < 2
and object_name( idx.id ) in ('object1','object2')
go
from sysindexes idx, sysobjects obj
where idx.indid < 2 and idx.id = obj.id and obj.type = 'U'
order by 1,2
go
select object_name( idx.id ), rowcnt(doampg)
from sysindexes idx
where idx.indid < 2
and object_name( idx.id ) in ('object1','object2')
go
Oracle
SELECT OWNER, TABLE_NAME, NUM_ROWS
FROM dba_tables
WHERE TABLE_NAME = UPPER( '&what_tbl.' );
SELECT OWNER, TABLE_NAME, NUM_ROWS
FROM dba_tables
ORDER BY 1,2;
FROM dba_tables
WHERE TABLE_NAME = UPPER( '&what_tbl.' );
SELECT OWNER, TABLE_NAME, NUM_ROWS
FROM dba_tables
ORDER BY 1,2;
Leave a Reply