>> It would be nice to have an SQL to drop all the objects in a database and
>> clean it out so to speak, we have a situation that we would like to make

a

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

Peter Ypenburg