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.


Peter Ypenburg

-----Original Message-----
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Thomas Steinmaurer
Sent: Friday, May 20, 2005 9:18 AM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] How to determine if a database is blank?

> I am looking for a way to determine (maybe using SQL) if a database
> has
> no objects (tables, sps, views, etc).

Simply query the proper RDB$ system tables, but be sure not to include
any mandatory system related database objects.


--
Best Regards,
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