>>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?

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


--
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