Board index » delphi » List of table in a database

John Chapman

Delphi Developer
Sun, 25 Jan 2004 00:00:00 GMT

List of table in a database

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

Delphi Developer
Sun, 25 Jan 2004 01:16:02 GMT

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

Team

Delphi Developer
Sun, 25 Jan 2004 01:14:04 GMT

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

John Chapm

Delphi Developer
Sun, 25 Jan 2004 06:25:02 GMT

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

John Chapma

Delphi Developer
Tue, 27 Jan 2004 20:53:01 GMT

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

John Chapma

Delphi Developer
Tue, 27 Jan 2004 20:52:43 GMT

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

ian

Delphi Developer
Wed, 28 Jan 2004 00:33:15 GMT

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

1. Getting a list of Tables in a Database

2. List of Tables in a Database

3. List of tables in a database

4. List inactive tables in a database

5. Getting a list of Tables in a Database

6. What do I need to do to get a list of tables in a database.

7. How to view the list of Table from a Database using SQL.

8. How to get a list of tables in a database as well as..

9. Listing Tables in a Database

10. List of tables in database