[firebird-support] How do return the number of object in a Firebird database

[Softtech Support]

Greetings All,

v1.5.3

I need to know how many tables, indicies, functions, stored procedures, etc are 
in my Firebird database.

Is there a quick way to determine this?

Thanks,
Mike

[Non-text portions of this message have been removed]

Re: [firebird-support] How do return the number of object in a Firebird database

[Josef Kokeš]

On 17.7.2013 13:55, Softtech Support wrote:
  
 
 Greetings All,
 
 v1.5.3
 
 I need to know how many tables, indicies, functions, stored procedures,
 etc are in my Firebird database.
 
 Is there a quick way to determine this?

-- stored procedures
SELECT COUNT(*)
FROM rdb$procedures
WHERE rdb$system_flag=0

-- functions
SELECT COUNT(*)
FROM rdb$functions
WHERE rdb$system_flag=0

-- indices
SELECT COUNT(*)
FROM rdb$indices
WHERE rdb$system_flag=0

-- tables
SELECT COUNT(*)
FROM rdb$relations
WHERE rdb$system_flag=0
  AND rdb$view_blr IS NULL

-- views
SELECT COUNT(*)
FROM rdb$relations
WHERE rdb$system_flag=0
  AND rdb$view_blr IS NOT NULL

Josef





++

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

* To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

* Your email settings:
Individual Email | Traditional

* To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

* To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

* To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

* Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/

Re: [firebird-support] How do return the number of object in a Firebird database

[Markus Ostenried]

On Wed, Jul 17, 2013 at 1:55 PM, Softtech Support stwiz...@att.net wrote:

 **


 Greetings All,

 v1.5.3

 I need to know how many tables, indicies, functions, stored procedures,
 etc are in my Firebird database.

 Is there a quick way to determine this?

See here, this should provide you with enough information:
http://www.alberton.info/firebird_sql_meta_info.html


[Non-text portions of this message have been removed]

Re: [firebird-support] How do return the number of object in a Firebird database

[Softtech Support]

Thanks Markus and Josef, just what I needed.  Much Appreciated

  - Original Message - 
  From: Markus Ostenried 
  To: firebird-support@yahoogroups.com 
  Sent: Wednesday, July 17, 2013 7:13 AM
  Subject: Re: [firebird-support] How do return the number of object in a 
Firebird database



  On Wed, Jul 17, 2013 at 1:55 PM, Softtech Support stwiz...@att.net wrote:

   **
  
  
   Greetings All,
  
   v1.5.3
  
   I need to know how many tables, indicies, functions, stored procedures,
   etc are in my Firebird database.
  
   Is there a quick way to determine this?
  
  See here, this should provide you with enough information:
  http://www.alberton.info/firebird_sql_meta_info.html

  [Non-text portions of this message have been removed]



  

[Non-text portions of this message have been removed]

Re: [firebird-support] How do return the number of object in a Firebird database

[Andrew Jeremy Gargan]

I find that quickly connecting to the DB with flamerobin GUI.



On Wed, Jul 17, 2013 at 1:55 PM, Softtech Support stwiz...@att.net wrote:

 **


 Greetings All,

 v1.5.3

 I need to know how many tables, indicies, functions, stored procedures,
 etc are in my Firebird database.

 Is there a quick way to determine this?

 Thanks,
 Mike

 [Non-text portions of this message have been removed]

  




-- 
Regards

Andrew Gargan


[Non-text portions of this message have been removed]