Subject Re: [firebird-support] Digest Number 9396
1. I create those temporary tables for one user only, for one transaction only, not visible for other users. I keep a track (log) of those tables and delete when I exit the program (drop table). The temporray table name is generated randomly 

'TEMP_TABLE_' + <random number> . 

2. the use of index is deliberately blocked, I want to do it this way, my query is faster. 

3. maybe I was not clear in stating my problem. 

I do not declare domains. Firebird declares those domains automatically when I create new tables (with usual types: Integer, char, etc). My problem is that when I create those tables, this automatic domain declaration declares (creates automatically) "huge" domain names (saw these with IBExpert, setting system domains visible). I can backup the database containing these domain names but I cannot restore normally. One screen capture here : 

Thank you,