Generally database metadata information (table names, column descriptions, etc) is vendor dependant, not ANSI SQL.

If you need to access to metadata programatically try using the JDBC API:
http://java.sun.com/j2se/1.4.2/docs/api/java/sql/package-summary.html
http://java.sun.com/j2se/1.4.2/docs/api/java/sql/DatabaseMetaData.html
http://java.sun.com/j2se/1.4.2/docs/api/java/sql/ResultSetMetaData.html

Ricardo Arg�ello


Ionel GARDAIS wrote:


Hi,

How to know if an SQL command is ANSI compliant or db
dependant ?

I need to know this for SHOW TABLES and SHOW COLUMNS
commands.

thanks,
ionel

___________________________________________________________
Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en fran�ais !
Yahoo! Mail : http://fr.mail.yahoo.com


------------------------------------------------------- This SF.net email is sponsored by: SF.net Giveback Program. Does SourceForge.net help you be more productive? Does it help you create better code? SHARE THE LOVE, and help us help YOU! Click Here: http://sourceforge.net/donate/ _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user




--


Ricardo Arg�ello [EMAIL PROTECTED] www.ndeveloper.com



-------------------------------------------------------
This SF.net email is sponsored by: SF.net Giveback Program.
Does SourceForge.net help you be more productive?  Does it
help you create better code?  SHARE THE LOVE, and help us help
YOU!  Click Here: http://sourceforge.net/donate/
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user

Reply via email to