sybase数据函数 sybase查询表数据量

create table #tableNames(TableName varchar(255)) 

 create table #aaa (num int ) 

 declare @n int 

 declare @dataTable varchar(255) 

 insert into #tableNames(TableName) 

 select name from sysobjects 


 set @n= (select count(*) from #tableNames) 

 while(@n>0) 

 begin 

 set @dataTable = (select Min(tm.TableName) from #tableNames tm) 


 if(exists(select 1 from sysobjects where name=@dataTable and type='U')) 

 begin 

 declare @sql varchar(1000) 

 declare @Num int 

 set @sql='insert into #aaa select count(1) from '+ @dataTable 

 exec ( @sql) 

 select @Num= num from #aaa 

 if @Num>0 

 print @dataTable 

 delete from #aaa 

 --select * from @dataTable 

 end 

 delete from #tableNames where TableName=@dataTable 

 select @n=(@n-1) 

 end 


if ( object_id('tempdb..#tableNames') is not null ) drop table #tableNames 

if ( object_id('tempdb..#aaa') is not null ) drop table #aaa