Played around with that some time ago and I think I remember just changing
table attribute
in the meta-data from persistent to one of the temporary table types does
the trick.
Be sure to try this on a copy of your database first.

-----Original Message-----
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Kok_BG
Sent: May-31-11 3:17 PM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Re: convert persistent table to temporary

Thank you Norman,
unfortunately this does not extract the linked objects - there many
procedures that are depend from this table, and i need a script which will
drop then, drop the table and recreate the procedures back.
Will check the FlameRobin, as Milan Suggest, I never used it before.

Regards

Nikolay

--- In firebird-support@yahoogroups.com, "Dunbar, Norman (Capgemini)"
<norman.dunbar.capgemini@...> wrote:

>
> Morning 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.
>
> I just tried this in IBExpert - the personal edition:
>
> Connect to my database then -
>
> Tools->Extract Metadata.
>
> On the Meta Objects tab, select the required tables and click the ">"
> button.
>
> On the Data Tables tab, make sure all tables are unselected, unless
> you want lots of "insert into " statements.
>
> Set the options required on the Options tab.
>
> In the drop down, select the required "Extract to" destination.
>
> Click the green ">" button.
>
> Job done.
>
>
> Good luck. Have fun.
>
>
> Cheers,
> Norm. (at work!)
>
>
>
> Information in this message may be confidential and may be legally

privileged. If you have received this message by mistake, please notify the
sender immediately, delete it and do not copy it to anyone else.

>
> We have checked this email and its attachments for viruses. But you should

still check any attachment before opening it.

> We may have to make this message and any reply to it public if asked to

under the Freedom of Information Act, Data Protection Act or for litigation.
Email messages and attachments sent to or from any Environment Agency
address may also be accessed by someone other than the sender or recipient,
for business purposes.

>
> If we have sent you information and you wish to use it please read our
> terms and conditions which you can get by calling us on 08708 506 506.
> Find out more about the Environment Agency at
> www.environment-agency.gov.uk
>

------------------------------------

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://www.firebirdsql.org and click the Resources item on the main
(top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Yahoo! Groups Links