A table that does not have data in the query database can only be queried for the naked eye.

CREATE TABLE # #temp (  ID int identity (),   tbname varchar)   CREATE Table # #temp1 (  ID int Identity (   tbname varchar)  go insert INTO # #temp select T.name as tbname from  sys.tables t go
  declare @n int   set @n=1  declare @tempid  varchar   set @tempid =0  declare @rows int  Select @rows =count (*) from # #temp while    @n <= @rows   begin        DECLARE @tempid1 varchar DECLARE @sql varchar (DECLARE) @TbName varchar ($)  Select  @TbName =tbname from # #temp  where id = @nset @sql = ' s Elect Count (*) from ' + @TbName; EXEC (@sql)--Query the number of data bars in this table select @TbName--Query the table name Set @n = @n + 1  

--drop TABLE # #temp

--drop TABLE # #temp1

　　

A table that does not have data in the query database can only be queried for the naked eye.