Beefy Boxes and Bandwidth Generously Provided by pair Networks
Pathologically Eclectic Rubbish Lister
 
PerlMonks  

Re: DBI recipes

by EdwardG (Vicar)
on Aug 18, 2003 at 07:52 UTC ( #284496=note: print w/replies, xml ) Need Help??


in reply to DBI recipes

++ Very useful node, thanks gmax.

For the sake of portability it might also be useful to note that ANSI SQL-92 provides a standard for querying table schema information:

select TABLE_NAME from INFORMATION_SCHEMA.TABLES

And to give an idea of what else is available via INFORMATION_SCHEMA;
SCHEMATA DOMAINS VIEWS COLUMNS TABLE_PRIVILEGES COLUMN_PRIVILEGES USAGE_PRIVILEGES DOMAIN_CONSTRAINTS TABLE_CONSTRAINTS REFERENTIAL_CONSTRAINTS CHECK_CONSTRAINTS KEY_COLUMN_USAGE ASSERTIONS VIEW_TABLE_USAGE VIEW_COLUMN_USAGE CONSTRAINT_TABLE_USAGE CONSTRAINT_COLUMN_USAGE CONSTRAINT_DOMAIN_USAGE
Source: An Introduction to Database Systems (7th edition), C.J. Date

Replies are listed 'Best First'.
Re: Re: DBI recipes
by dragonchild (Archbishop) on Feb 16, 2004 at 21:40 UTC
    I'd like to point out that while most databases are mostly SQL-92 compliant, INFORMATION_SCHEMA.TABLES is not implemented in Oracle 9.2.0.4 (the latest patch release, that I'm aware of).

    I don't know if any other database implements this or not.

    ------
    We are the carpenters and bricklayers of the Information Age.

    Please remember that I'm crufty and crochety. All opinions are purely mine and all code is untested, unless otherwise specified.

      It's a fair point you make. Both Oracle and Microsoft continue to stretch the meaning of compliance.

      It is almost meaningless now but at this rate by 2020 it could simply mean that the product engineers know how to spell I-S-O.

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://284496]
help
Chatterbox?
[oiskuu]: Someone needs to re-read How do I use the power of consideration responsibly? carefully. Consideration is not intended for stamping out humor, AFAIK.
[oiskuu]: E.g. Re^3: Big thank you to the Perl community. is surely dry humor (not mine). Don't they teach humor in german schools!?
[LanX]: you don't see the whole picture
[LanX]: But reu germans have no humor, better to refrain from this site till the troll is gone...
[LanX]: true

How do I use this? | Other CB clients
Other Users?
Others lurking in the Monastery: (11)
As of 2017-04-27 19:53 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    I'm a fool:











    Results (512 votes). Check out past polls.