Menu
We have a single SQL script for execution on multiple types of database. Is it possible to get the type of current database on which SQL script is executing?
Note: We can't use non standard SQL i.e . TSQL etc.
225
One way to get the name of the underlying database you have connected with is by invoking the getDatabaseProductName() method of the DatabaseMetaData interface. This method returns the name of the underlying database in String format.
Even though there are no SQL queries that tell you the database type, there are queries which only work in certain database types and not in others. For example, SELECT version() will tell you the version of the current database if your database is PostgreSQL but it will cause error if you try to run it in Microsoft.
No, there is nothing in ANSI SQL about determining the database vendor.
78
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
