Hi Nikolay,

> The best for sure is to drop and recreate the tables, but there are a lot of depend objects so it will be hard manual work - i am using the great IBExpert, but there is no recreate script for tables - only for views.

If there is no table recreation feature, how about extracting the
database metadata and from that, you should be able to convert the
current persistent temprary tables to proper GTTs.

If IBExpert won't let you do it, then "isql -x -user xxxx -password
yyyyy database_name > scriptfile.sql" certainly will.

> I am temped to change the RDB$RELATIONS.RDB$RELATION_TYPE from 0 to 5.

No, no, no and no! It may *appear* to work, but there's no telling what
damage you may have done behind the scenes.

Never ever, fiddle in the system tables. SELECT from them if you like,
but don't INSERT, DELETE or UPDATE.

It really is a good way to trash a database.

> What do you think, is it dangerous?

Yes. Apart from the above, I rather suspect Helen may give you grief as
well! ;-)


Cheers,
Norm.

--
Norman Dunbar
Dunbar IT Consultants Ltd

Registered address:
Thorpe House
61 Richardshaw Lane
Pudsey
West Yorkshire
United Kingdom
LS28 7EL

Company Number: 05132767