Alter Temporary table in Memory Issue.

[Ritu Tandon]

hi,

I am creating a temporary table in memory engine. Every time I call the procedure I drop these tables by checking if they already exist or not.

Now I am altering the table by adding some columns to this table. (These columns come on the basis of some results).

Now I use the Select * clause.

The first time it works fine. But 2nd time if my colmns change then even though I am dropping the earlier tables and creating the new ones I get the same old columns.

Is it because of some caching?

Thanks.
R