Hi,

> I need to create a temporary table inside a store procedure. And once I

called the store procedure, I want to delete that temporary table
automatically.

> How should I do this?

With MS SQL Server.

> Anybody has a good reference?

You cannot do this in Firebird or InterBase.

Perhaps you should explain the problem - it might be better to do it in
another way
or maybe we know a work-around.


With regards,

Martijn Tonies
Database Workbench - the developer tool for InterBase & Firebird
Upscene Productions
http://www.upscene.com

See you at the First European Firebird Conference in May in Fulda, Germany
http://www.firebird-conference.com