> when i do drop table, sometime it's take hours to return (especially on
> big table)
> why ?

Are you perhaps running the DROP TABLE statement in a transaction with
the WAIT option, while the table is in use by concurrent transactions?


--
With regards,

Thomas Steinmaurer
Upscene Productions
http://www.upscene.com
http://blog.upscene.com/thomas/

Download LogManager Series, FB TraceManager today!
Continuous Database Monitoring Solutions supporting
Firebird, InterBase, Advantage Database, MS SQL Server
and NexusDB!