예전에 프로시저로 만들었었는데. 

--> 

http://222.112.187.32:9090/solui/blueboard/board/solui_study/content.asp?b_nm=solui_study&s_num=61&GotoPage=1&order=



그냥 sql문도 함 보자..



set nocount on

declare @name varchar(80)

select @name = '



while @name is not null

begin

  select @name = min(table_name) from information_schema.tables

  where table_type = 'base table' and table_name > @name



  if @name is not null

  begin

   select '가져온 테이블 이름:'+ @name

   exec ('select count(*) from ' + @name)

  end

end

날짜: 2004-05-18 14:44:42, 조회수: 2737