I need to know whether any database supports double quotes as a part of their table name. I am especially interested in JDBC compliant databases. And if they do, can I please know how?
According to the SQL standard, this should be possible by doubling the double quotes (similar to escaping single quotes in string constants).
At least Postgres does support this (and Oracle does not, resulting in "ORA-03001: unimplemented feature")
create table "really""stupid_name"(id integer);
Online example: https://rextester.com/JYCW13692
However, using quoted identifiers is a bad idea to begin with. Let alone identifiers that in turn contain double quotes.
I would strongly suggest you do not do this.
Server version: 8.0.12 MySQL Community Server - GPL
mysql> CREATE TABLE `test"d"quote` (id int); Query OK, 0 rows affected (0.31 sec) mysql> insert into `test"d"quote` values (1), (11); Query OK, 2 rows affected (0.11 sec) Records: 2 Duplicates: 0 Warnings: 0 mysql> select * from `test"d"quote`; +------+ | id | +------+ | 1 | | 11 | +------+ 2 rows in set (0.00 sec) mysql> drop table `test"d"quote`; Query OK, 0 rows affected (0.22 sec)