s. isaac dealey wrote: >> SELECT * FROM INFORMATION_SCHEMA.TABLES > > Yep... information_schema is apparently an actual standard...
ISO/IEC 9075-11:2003 > problem is > most people don't know about it because you have to fork over $200 or > somesuch to see the specs for it. You just need a decent library :) Or for the 1999 version: http://www.ncb.ernet.in/education/modules/dbms/SQL99/ansi-iso-9075-2-1999.pdf (I don't know if it is the full and final version, most versions that are available as a free download are drafts.) > Which is probably why more developers > aren't aware of it and also probably why more db's don't support it, You really think that Oracle, IBM, Teradata etc. have a problem paying $200 for a standard? They are on the SQL Standard committee themselves, so they have plenty of spare copies. They would just much rather focus on where they are different and unique then help the commoditization of databases forward. Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296483 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
