Board index » delphi » List of table in a database

List of table in a database

How do you list all the user tables in an Interbase database please?
 

Re:List of table in a database


"John Chapman" <cha...@my-deja.com> schrieb im Newsbeitrag
news:3b70117c_1@dnews...

Quote
> How do you list all the user tables in an Interbase database please?

select RDB$RELATION_NAME from RDB$RELATIONS where RDB$SYSTEM_FLAG = 0
--

Regards,
Tilo Muetze

Re:List of table in a database


Quote
John Chapman wrote:

> How do you list all the user tables in an Interbase database please?

SELECT
  RDB$RELATION_NAME
FROM
  RDB$RELATIONS
WHERE
  RDB$SYSTEM_FLAG <> 1 /* Exclude system tables */
    AND
  RDB$VIEW_BLR IS NULL /* Exclude VIEWs */

        HTH,

        -Craig

--
 Craig Stuntz (TeamB) Vertex Systems Corp. Columbus, OH
We're hiring: http://www.vertexsoftware.com/careerops.htm#sd
     Delphi/InterBase WebLog: http://delphi.weblogs.com

Re:List of table in a database


Thanks for this works a treat.

"Craig Stuntz (TeamB)" <cstuntz@no_spam.vertexsoftware.com> wrote in message <news:3B7021DC.AF73B58E@no_spam.vertexsoftware.com>...

Quote
> John Chapman wrote:

> > How do you list all the user tables in an Interbase database please?

> SELECT
>   RDB$RELATION_NAME
> FROM
>   RDB$RELATIONS
> WHERE
>   RDB$SYSTEM_FLAG <> 1 /* Exclude system tables */
>     AND
>   RDB$VIEW_BLR IS NULL /* Exclude VIEWs */

>    HTH,

>    -Craig

Re:List of table in a database


Thanks works a treat.
"Craig Stuntz (TeamB)" <cstuntz@no_spam.vertexsoftware.com> wrote in message
news:3B7021DC.AF73B58E@no_spam.vertexsoftware.com...
Quote

> John Chapman wrote:

> > How do you list all the user tables in an Interbase database please?

> SELECT
>   RDB$RELATION_NAME
> FROM
>   RDB$RELATIONS
> WHERE
>   RDB$SYSTEM_FLAG <> 1 /* Exclude system tables */
>     AND
>   RDB$VIEW_BLR IS NULL /* Exclude VIEWs */

> HTH,

> -Craig

> --
>  Craig Stuntz (TeamB) Vertex Systems Corp. Columbus, OH
> We're hiring: http://www.vertexsoftware.com/careerops.htm#sd
>      Delphi/InterBase WebLog: http://delphi.weblogs.com

Re:List of table in a database


Thans
Quote
"Tilo Muetze" <tmue...@iq-compusulting.de> wrote in message

news:9kp7oi$v0q$03$1@news.t-online.com...
Quote
> "John Chapman" <cha...@my-deja.com> schrieb im Newsbeitrag
> news:3b70117c_1@dnews...
> > How do you list all the user tables in an Interbase database please?

> select RDB$RELATION_NAME from RDB$RELATIONS where RDB$SYSTEM_FLAG = 0
> --

> Regards,
> Tilo Muetze

Re:List of table in a database


Quote
John Chapman wrote:

 > How do you list all the user tables in an Interbase database please?
 >

in isql, whats wrong with "show tables"
also works for index, trigger, ....

HTH
Ian

Other Threads