>If you want to keep all database objects, but without any data, then
>simply make a metadata only backup and restore it.

Wow, you can do that???

Peter Ypenburg

-----Original Message-----
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Thomas Steinmaurer
Subject: Re: [firebird-support] How to determine if a database is blank?

>>Why not simply create a new database?
>
>
> Yes that would work, although thinking about it to drop all the tables and
> constraints is not what I need, so my previous mail was misleading.
>
> When thinking about it what we need is to be able to take a database and
> delete all the rows on all the tables and keep the tables, indexes,
> constraints all in place. This has to be done in the reverse order of how
> data in one table is dependant on data in other tables.
>
> I have asked sometime ago if some one has made a sql statement that can
> select the dependencies of the data from the system tables in order to run

a

> various range of "delete from table" statements so that the database can

be

> made "blank" form a data point of view. I do not know much about the
> structure of the system tables and have not been able to find a good
> tutorial that explains what the data in the system tables mean. Does any

one

> know of documentation in this regard?
>
> Is this a tall order, is it possible to do this?

--
HTH,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2 (NEW!)
Upscene Productions
http://www.upscene.com


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

Visit http://firebird.sourceforge.net 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