| Subject | convert persistent table to temporary |
|---|---|
| Author | Kok_BG |
| Post date | 2011-05-28T21:58:45Z |
Hi group
I want to use the power of GTT in my app.
Unfortunately the app was developed prior FB 2.1, so the tables i need as temporary are persistent at the moment.
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.
I am temped to change the RDB$RELATIONS.RDB$RELATION_TYPE from 0 to 5.
What do you think, is it dangerous?
Regards
Nikolay
I want to use the power of GTT in my app.
Unfortunately the app was developed prior FB 2.1, so the tables i need as temporary are persistent at the moment.
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.
I am temped to change the RDB$RELATIONS.RDB$RELATION_TYPE from 0 to 5.
What do you think, is it dangerous?
Regards
Nikolay