비슷한 테이블 이름을 가진녀석 몽땅 날려버리기

요건.. 아래쪽에 있는 문장의 응용 버전이다.
테이블을 모두 지우기가 정말 귀찮을 경우에 사용하는 방법인데.. 사이트 나가서 실행하면 안된다.

select object_name(id) from sysindexes where id in
(select id from sysobjects where name like 'logins%') and indid in (0, 1)

select object_name(id) from sysindexes where id in
(select id from sysobjects where name like 'loginerrors%') and indid in (0, 1)

select object_name(id) from sysindexes where id in
(select id from sysobjects where name like 'logouts%') and indid in (0, 1)

select object_name(id) from sysindexes where id in
(select id from sysobjects where name like 'querys%') and indid in (0, 1)

select object_name(id) from sysindexes where id in
(select id from sysobjects where name like 'queryerrors%') and indid in (0, 1)

select object_name(id) from sysindexes where id in
(select id from sysobjects where name like 'responses%') and indid in (0, 1)

select object_name(id) from sysindexes where id in
(select id from sysobjects where name like 'results%') and indid in (0, 1)

-- 아래 FOR 이후 부분을 모두 이것으로 교체 해 주고 실행하면 된다.

declare @tablename varchar(128) , @SQL varchar(2000)

DECLARE cur_droptable CURSOR
READ_ONLY
FOR select object_name(id) from sysindexes where id in
(select id from sysobjects where name like 'logins%') and indid in (0, 1)

OPEN cur_droptable

FETCH NEXT FROM cur_droptable INTO @tablename
WHILE (@@fetch_status <> -1)
BEGIN
    IF (@@fetch_status <> -2)
    BEGIN

    SET @SQL = 'DROP TABLE ' + @tablename
   
    EXEC (@SQL)

    END
    FETCH NEXT FROM cur_droptable INTO @tablename
END

CLOSE cur_droptable
DEALLOCATE cur_droptable
GO

관련해서 나중에 파일 첨부 해 둬야겠지만.. 일단 위에 것 만으로도 사용이 가능하다 싶다.