• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 436
  • Last Modified:

show tables using sql92


Am running frontbase on linux, and am using the command line tool sql92.

Can connect to a database using...

sql92#7> connect to testdb user _system;

how do i interigate the database so that i can get a list of the tables in that datbase.

Any ideas?
0
toakeley
Asked:
toakeley
2 Solutions
 
David ToddSenior DBACommented:
Hi,

Try

select *
from information_schema.tables

SQL Server Books on Line lists this as part of SQL-92 standard.

Regards
  David
0
 
vk33Commented:
Hi!

An extract from SQL-92 specification:

         CREATE VIEW TABLES
              AS SELECT
                TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME, TABLE_TYPE
              FROM DEFINITION_SCHEMA.TABLES
                  WHERE ( TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME )
                    IN (
                        SELECT TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME
                         FROM DEFINITION_SCHEMA.TABLE_PRIVILEGES
                           WHERE GRANTEE IN ( 'PUBLIC', CURRENT_USER )
                        UNION
                        SELECT TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME
                         FROM DEFINITION_SCHEMA.COLUMN_PRIVILEGES
                           WHERE GRANTEE IN ( 'PUBLIC', CURRENT_USER ) )
                  AND TABLE_CATALOG
                    = ( SELECT CATALOG_NAME FROM INFORMATION_SCHEMA_
              CATALOG_NAME )

You can see the full document here (it's quite large!):

http://luuk.xs4all.nl/sql/sql1992.txt

Regards!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Windows 7 Basic

This introductory course to Windows 7 environment will teach you about working with the Windows operating system. You will learn about basic functions including start menu; the desktop; managing files, folders, and libraries.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now