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