How to clear or drop Declared table

Question

How do I clear/reset/drop temporary created table that is in loop?

Another loop at the top with extra code...

How do I reset/drop the declared table up here or below?

 Declare @Aresource table(idr int identity(1,1), id int)
        Insert into @Aresource (id)
        SELECT  idr = AssignmentImageId
        FROM  VLP2014..Assignment 
                 Where AssignmentId = @ida 
        Declare @ari int
        Declare @aricnt int
        select @ari = min(idr) - 1, @aricnt = max(idr) from @Aresource
        While @ari < @aricnt
        Begin
        Select @ari = @ari + 1
        Declare @arid int
        select @arid = id from @Aresource where idr = @ari

How do I reset/drop the declared table here?
some more code...

I have tried the normal DROP TABLE if exists but since it is Declared (temp table) I cant seem to be able to call it.

score 0 · Answer 1 · answered Feb 12 '15 at 18:48

Fixed issue with adding normal temp table to the db and then removing it after the loop.

Create Table #Aresource (idr int identity(1,1), id int)
    Insert into #Aresource (id)
    SELECT  idr = AssignmentImageId
    FROM  VLP2014..Assignment 
             Where AssignmentId = @ida 
    Declare @ari int
    Declare @aricnt int
    select @ari = min(idr) - 1, @aricnt = max(idr) from #Aresource
    While @ari < @aricnt
    Begin
    Select @ari = @ari + 1
    Declare @arid int
    select @arid = id from #Aresource where idr = @ari

...... more code ....

end
Drop table #Aresource

How to clear or drop Declared table

1 Answers1