Subject | Re: [firebird-support] How to find List of All Tables, Views, Triggers and Stored Procedures |
---|---|
Author | Almond |
Post date | 2003-11-12T07:01:16Z |
Tables and views.
SELECT RDB$RELATION_NAME as tablename
FROM RDB$RELATIONS WHERE RDB$SYSTEM_FLAG = '0'
;
At 10:20 03/11/12 +0700, you wrote:
SELECT RDB$RELATION_NAME as tablename
FROM RDB$RELATIONS WHERE RDB$SYSTEM_FLAG = '0'
;
At 10:20 03/11/12 +0700, you wrote:
>Is there any way I can find those items via SQL statement ?
>I know they are stored into some system tables but I just don't know which
>nor to retreat them ..
>
>Plz Help ...
>
>
>
>To unsubscribe from this group, send an email to:
>firebird-support-unsubscribe@yahoogroups.com
>
>
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/